zoom in on an Excel chart to get its close-up view<\/strong>. The magnification of the chart is increased and this improves the visibility of its values.<\/p>\n\n\n\nIn this tutorial, we explore different Zoom methods <\/strong>that we can use to increase the magnification of Excel charts<\/strong>.<\/p>\n\n\n\nMethods of zooming in on Excel charts<\/h2>\n\n\n\nMethod 1: Use the Zoom Slider<\/h3>\n\n\n\n We use the Zoom Slider<\/strong> to increase the magnification of an Excel chart. This control is located in the bottom right corner of the Excel Window<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nTo apply the Zoom Slider, we use the following steps:<\/p>\n\n\n\n
\nClick the Zoom Slider control.<\/li>\n\n\n\n Drag the slider<\/strong> bar to the right to the desired location that corresponds to the desired magnification percentage. Alternatively, we can click Zoom In (+) button <\/strong>to increase the magnification in gradual increments of 10%.<\/li>\n<\/ol>\n\n\n\nAn alternative way of using the Zoom Slider control:<\/p>\n\n\n\n
\nSelect the Excel chart that we want to zoom in on. As in the example below:<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick on the Zoom level percentage<\/strong> button to open the Zoom dialog box<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSelect Fit selection<\/strong> in the Zoom dialog box<\/strong> and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe chart is magnified to fit in the Excel Window.<\/p>\n\n\n\n <\/figure>\n\n\n\nMethod 2: Use View Tab on Excel Ribbon<\/h3>\n\n\n\n On the View Tab<\/strong> click Zoom<\/strong> to open the Zoom dialog box<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe Zoom dialog box<\/strong> pops up. Select the desired magnification percentage in the Zoom dialog box and click OK<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe can use the Zoom to Selection command to fit the chart in the Excel Window. We first of all need to select the chart and then click the Zoom to selection button.<\/p>\n\n\n\n <\/figure>\n\n\n\nMethod 3: Use Ctrl and scroll wheel<\/h3>\n\n\n\n In this method, we hold down the Ctrl <\/strong>key on the keyboard while scrolling the wheel up. This increases the magnification of the chart by increments of 15%.<\/p>\n\n\n\nMethod 4: Use Zoom on roll with IntelliMouse<\/h3>\n\n\n\n If we need to frequently adjust the zoom level of charts, we can use the Zoom on roll with IntelliMouse<\/strong> option. This option allows us to use the mouse scroll wheel to increase the magnification of charts without necessarily having to hold down the Ctrl <\/strong>key on the keyboard.<\/p>\n\n\n\nBecause this option is disabled in Excel by default we first have to enable it by using the steps below:<\/p>\n\n\n\n
\nSelect File<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSelect Options<\/strong> on the sidebar.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSelect Advanced<\/strong> in the left-hand panel of the Excel Options<\/strong> dialog box and select Zoom on roll with IntelliMouse <\/strong>option under the Editing Options<\/strong> section and click OK.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nOnce the option is activated, we can scroll the wheel up to increase the magnification of the charts.<\/p>\n\n\n\n
Method 5: Use Keyboard Shortcut<\/h3>\n\n\n\n We can use the keyboard shortcut Ctrl + Plus key on the numeric keypad<\/strong> to zoom in. This shortcut zooms in by increments of 10%.<\/p>\n\n\n\nThis method increases the magnification of the sheet that contains the chart. Ensure that the chart is deselected before applying the shortcut.<\/p>\n\n\n\n
Method 6: Move the embedded chart to the chart sheet<\/h3>\n\n\n\n Charts that are embedded in worksheets tend to be smaller than those in chart sheets. We can move our embedded chart to a chart sheet so that it becomes bigger.<\/p>\n\n\n\n
We use the following steps to move the embedded chart:<\/p>\n\n\n\n
\nSelect the embedded chart as in the example below.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick Chart Tools >> Design >> Location >> Move Chart <\/strong>to open the Move Chart<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Move Chart<\/strong> dialog box select New sheet<\/strong> and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe chart is moved to a chart sheet and it looks much bigger.<\/p>\n\n\n\n <\/figure>\n\n\n\nMethod 7: Use Excel VBA<\/h3>\n\n\n\n We have seen so far that the in-built methods of zooming in an increment of 10%-15%. These are relatively large increments. Sometimes we may want more control over the zoom increments. Excel does not have an option for this so we have to resort to Excel VBA<\/strong>.<\/p>\n\n\n\nIn Excel VBA we can create a subroutine in our Personal Macro Workbook<\/strong> to increment zoom up by more controlled amounts. We then can assign to it a keyboard shortcut for quick access.<\/p>\n\n\n\nBefore we can use the Personal Macro Workbook<\/strong>, we have to activate it using the following steps:<\/p>\n\n\n\n\nClick Developer >> Code >> Record Macro<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Record Macro<\/strong> dialog box select Personal Macro Workbook<\/strong> in the Store macro in<\/strong> the drop-down list and click OK.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSince our goal is simply to activate a Macro Personal Workbook<\/strong>, click Developer >> Code >> Stop Recording<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nSave and close the workbook. The Macro Personal Workbook<\/strong> has been activated and it will be opened automatically in the background whenever we start Excel.<\/li>\n\n\n\nRe-open the Excel workbook that contains the chart.<\/li>\n\n\n\n Press Alt + F11<\/strong> to open the Visual Basic Editor<\/strong>.<\/li>\n\n\n\nIn the Project Window<\/strong> right-click the VBAProject (PERSONAL.XLSB) <\/strong>and click Insert >> Module<\/strong> on the shortcut menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the inserted module type in the following procedure:<\/li>\n<\/ol>\n\n\n\nSub zoomInChart()\n\t'Purpose: Zoom in on the ActiveSheet by a given increment\n\tDim pctIncrement As Integer\n\t'Desired Zoom Increment percentage\n \tpctIncrement = 5\n\t'Increase Zoom percentage\n \t\tOn Error GoTo MaxZoomReached\n \t\t\tActiveWindow.Zoom = ActiveWindow.Zoom + pctIncrement\n \t\tOn Error GoTo 0\nExit Sub\n'Error Message\nMaxZoomReached:\n MsgBox \"Cannot zoom in any further\", vbExclamation\nEnd Sub<\/code><\/pre>\n\n\n\n\nPress Alt + F11<\/strong> to switch back to the active worksheet.<\/li>\n\n\n\nPress Alt + F8<\/strong> to open the Macro <\/strong>dialog box. Ensure that the PERSONAL.XLSB!zoomInChart <\/strong>is selected and click Options<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nAssign a keyboard shortcut to the Macro in the Macro Options<\/strong> dialog box and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWhenever we press the keyboard shortcut we have assigned, in this case, Ctrl + Shift + Z<\/strong>, the Excel chart is zoomed in by an increment of 5% as specified in the procedure.<\/p>\n\n\n\nConclusion<\/h2>\n\n\n\n When we work with Excel charts, there are times when we need to zoom in on the charts for a close-up view.<\/p>\n\n\n\n
In this tutorial, we have explored several zoom methods that we can use to zoom in on Excel charts. They include using the Zoom Slider control<\/strong>, using the scroll wheel,<\/strong> using the keyboard shortcut<\/strong>, moving embedded chart to a chart sheet<\/strong>, using the Zoom buttons on the View tab<\/strong>, and using the Excel VBA<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"We zoom in on an Excel chart to get its close-up view. The magnification of the chart is increased and this improves the…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Zoom in on Excel Chart<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n