Click on the Developer tab, then from the Insert option of the Controls group, select the scroll bar control: Now, in the column “F” next to the small table we created, click and drag your cursor to insert the scrolling control bar. Now we need to add the scroll bar control. Name Required/Optional Data type Description Left: Required: Double: The initial coordinates of the new object (in points), relative to the upper-left corner of cell A1 on a worksheet or to the upper-left corner of a chart. You could however select the cells surrounding your chart and then select the "Fit Selection" zoom feature and there is your kinda' yes solution.
Here are the Excel 2007 zoom tools Zooming into Your Excel 2007 Worksheets The "Fit Selection" zoom feature doesn't work on a chart selection. asy-to-use scientific graphing and data analysis software, with powerful curve fitting. Import your own data into our demo and try it for yourself. Move or resize the rectangle on your original graph and the Enlarged graph is updated. Note that this Enlarged graph is dynamic. With a graph active, press CTRL then click the Scale In button ( Tools toolbar) and drag out a rectangle on your 2D graph. No step-by-step zooming out You can zoom in more than one time, but you cannot get back step-by-step. There is no flipping over above or left to the position where you clicked first. to the right and down from the point you started. The rectangle defining the zoom area can only be resized South-East, i.e. Also click "Fixed" next to Maximum, and enter 26 in the box next to it. Click "Fixed" next to Minimum, and enter 24 in the box next to it. How to zoom in on part of a graph in Excelĭouble-click any of the y-axis value labels.
But, in Excel, to add a scrollbar to a chart is somewhat difficult, so please finish this task with following operations step by step. If there are lots of data needed to be displayed in your chart, you can add a scrollbar into your chart, when you drag the scrollbar, you could view the data’s changing continuously. Ensure that the data is clean and free from errors. Place the data required for the stock chart (stock price and volume in our case) in an excel spreadsheet. To create a stock chart in Excel with scroll and zoom functionality, follow these steps: 1. 2 Click and drag over the chart to add a scroll bar. Click "Insert" from the Controls group, and click the scroll bar icon. How to add zoom and scroll to an Excel chartĬlick "Developer" from Excel's ribbon.
0 kommentar(er)
