Add Horizontal Line To Excel Chart
Add Horizontal Line To Excel Chart. Once you click on change chart type option, you'll get a dialog box for formatting. Right click on the added series, and change its chart type to XY.
Re: Adding a horizontal line on X Axis of a Pivot Chart. but am unable to do so by adding a data series, since for some reason, the pivot chart does not allow addition of a new data series or a different axis as per below screenshot. Copy the data, select the chart, and Paste Special to add the data as a new series. We will create it based on the data of NBA players and their points in one night of basketball:.
In the Add line to chart dialog, please check the Average option, and click the Ok button.
Make sure that the checkbox next to 'Gridlines' is checked.
If you want to add a horizontal line in excel graph then you should watch this video because I had shown a p. Adding Average Horizontal Line to Excel Bar Chart. This will display the major gridlines on your chart.
Rating: 100% based on 788 ratings. 5 user reviews.
Arleen Butler
Thank you for reading this blog. If you have any query or suggestion please free leave a comment below.
0 Response to "Add Horizontal Line To Excel Chart"
Post a Comment