How to Zoom in on Excel Graph

In this lesson you learn how to zoom in your graph. It will help you improving visibility of values in your graph.

The most important in charting is visibility. In this lesson you will learn how to zoom in your graph.

Zooming Sheet

The easiest way is to zoom in the Sheet. To do it go to right corner of screen and click + button

Zooming Sheet

It makes whole Sheet bigger. Chart will be bigger too.

Changing scale of axis

Other method is to change scale of axis. Excel automatcally fits scale of axis.

If your chart looks that:

Zooming Graph Wrong Scale

You can change it to that look:

Zooming Graph Good Scale

You can easy improve wrong scale yourselves. Right click axis and select Format Axis.

Zooming Graph Format Axis

Change Min and Max values to fit them to your values.

Zooming Graph Min Max Values

Notice that scale of proper axis starts from $40,25. You don’t need to starts from $0.

Using logarithmic scale

The other way is using logarithmic scale. Use logarithmic scale when there is huge difference between values at your graph.

Zooming Graph Logarithmic Scale

Right click axis and next Format Axis. Tick Logarithmic scale check box.

Zooming Graph Logarithmic Scale Checkbox

Now graph looks much better. Every 3 lines are visible well.

Zooming Graph Logarithmic Axis OK

Using Zoom button

You can use a dedicated Zoom button to zoom your graph in.

Go to the View tab and select the Zoom In option from the Zoom group. You can also use the keyboard shortcut Ctrl + Plus sign to zoom in.

See also  How to Make a Pie chart

Alternatively, you can click and drag a rectangle around the area you want to zoom in on. When you release the mouse button, the graph will zoom in on the selected area.

To zoom out, go to the View tab and select the Zoom Out option from the Zoom group. You can also use the keyboard shortcut Ctrl + Minus sign to zoom out.

If you want to return to the original view of the graph, go to the View tab and select the 100% option from the Zoom group.

You can also use the mouse wheel to zoom in and out on an Excel graph. Simply hold down the Ctrl key and use the mouse wheel to zoom in or out.

Selective Zoom

If you want to zoom in on a specific portion of your graph, you can click and drag to create a rectangle around that area. Once you release the mouse button, Excel will zoom in on the selected section, providing a closer look at your data.

There are so many ways to zoom in Excel sheet. Choose the one you like the most.