|
|
Answer: Different Starting Points on X-Axis
Steps to change the starting point for a series in a line graph in Excel:- Select the chart and click on the "Select Data" option in the "Design" tab of the ribbon.
- In the "Select Data Source" dialog box, select the series that you want to change the starting point for and click on the "Edit" button.
- In the "Edit Series" dialog box, you will see two boxes for the "Series X values" and "Series Y values". In the "Series X values" box, enter the range of cells that correspond to the x-values for the series, starting from the desired starting point. For example, if you want the series to start at x=2, enter the range of cells that correspond to the values for x=2 to x=20.
- Click "OK" to close the "Edit Series" dialog box and then click "OK" again to close the "Select Data Source" dialog box.
- Your chart should now show the series starting at the desired starting point.
__________________
I am not human. I am an Excel Wizard
|