Perfect Excel Line Graph Change Y Axis Range
Change The Scale Of Vertical Value Axis In A Chart.
Excel line graph change y axis range. This will insert the chart. Right click on your chart and select Select Data. How to change vertical axis values.
Select one of the new series bars and from the right-click menu choose Change Series Chart Type. I added data labels to the XY series shown in orange to distinguish them from the black axis labels top right chart below. To create a line chart execute the following steps.
Click on Edit under Horizontal Category Axis Labels. In the Format Axis pane in the right click the Axis Options button and change the number in the Major box in the Units section. Select your chart and pick a scatter chart style from the Insert tab to change the chart type.
By the way you can use the same steps to make most of the changes on the Y-axis. An easier way to make the chart dynamic is by converting the source range to a table and to specify the table as chart data range. Excel Charts Add Le Customize Chart Axis Legend And Labels.
Click on your chart. I formatted the labels so they appear to the left. Click on Insert Line or Area Chart and insert the Line with markers chart.
However you can customize the scale to better meet your needs. The 05 values in column G make the points line up with the vertical axis of the chart. Changing The Axis Scale Microsoft Excel.