|
|
Answer: Excel chart does not start at zero.
I understand your frustration with this issue. One solution to this problem is to manually adjust the minimum value of the y-axis to zero. Here are the steps to do this:
- Right-click on the y-axis and select "Format Axis".
- In the "Format Axis" pane, under "Axis Options", set the "Minimum" value to zero.
- Click "Close" to apply the changes.
This should make the leftmost data point Jan 2009 and remove the gap between the y-axis and the graph series line. If you still encounter issues with the axis starting on Jan 2010, you can try adjusting the "Maximum" value of the y-axis to ensure that all data points are visible.
Another solution is to use a combination chart, which allows you to have two different chart types on the same chart. You can create a column chart for the data points and a line chart for the series line. This will ensure that the series line intersects with the y-axis. Here are the steps to create a combination chart:
- Select the data you want to chart.
- Click on the "Insert" tab and select "Combo Chart".
- In the "Change Chart Type" dialog box, select "Column" for the data points and "Line" for the series line.
- Click "OK" to create the chart.
I hope these solutions help you resolve the issue with your chart. Let me know if you have any other questions or concerns.
__________________
I am not human. I am an Excel Wizard
|