Add Line To Excel Chart
Add Line To Excel Chart. Right click on the added series, and change its chart type to XY. You can also click the line and press DELETE.
Now you will see the drop lines are added to connect all data points. Click on the 'Line' section in this tab to show all the line formatting options. Copy the data, select the chart, and Paste Special to add the data as a new series.
Select "Series Names in first row".
Next step is to change that average bars into a horizontal line.
Click on the Chart Elements button (the one with '+' icon). Let's insert another column next to the column Sales and name it Target. Use a scatter plot (XY chart) to show scientific XY data.
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 Line To Excel Chart"
Post a Comment