Is this your first time on Eas圜lick? We’ll be more than happy to welcome you in our online community. If you found this tutorial helpful, give us a like and watch other video tutorials by Eas圜lick Academy. Learn how to use Excel in a quick and easy way! How to Add an Average Line in an Excel Graph.Right click a column in the chart, and select Format Data Series in the context menu. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group. The links are included in the list below.ĭon’t miss out a great opportunity to learn: Following the below steps, you will find that making two y axes in chart is very easy. 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
0 kommentar(er)
