how to plot a graph in excel with lines going through axis

How to Add an Average Line in an Excel Graph.The links are included in the list below.ĭon’t miss out a great opportunity to learn: If you’re interested in learning more, for example how to add or adjust other elements in a graph, have a look through more tutorials by Eas圜lick Academy. This is a handy way to change scaling in a graph according to your needs. If we change the ‘Major’ units value from 20 to 40 and press Enter, the units on the vertical axis will change based on the adjusted settings. Now, the unit value is 20, which means that the difference between the numbers on this axis is 20. When we press Enter, Excel displays the changes in the graph, which makes the data clearer and easy on the eye.Īt the same time, we can adjust the units displayed on the vertical axis.

To improve the readability of the graph, let’s change the upper bound to 160. How to Change the Scale of Vertical Axis in ExcelĬurrently, the bottom bound value is 0 and the upper bound value is 400. In ‘Axis Options’, we can set the graph bounds and units as needed.īut let’s go through it step by step. Select ‘Format Axis’, after which you’ll see a pane with additional options appear on the right. To adjust the scale of a graph, right-click on the vertical axis of the graph, just where you see the values. 2 How to Change the Scale of Vertical Axis in Excel How to Adjust the Scale of a Graph

How to plot a graph in excel with lines going through axis