Hi there!
To align the zero point on the primary and secondary axis, you can follow these steps:
- Select the chart and go to the "Format" tab in the ribbon.
- Click on "Horizontal (Category) Axis" and select "Format Axis" from the drop-down menu.
- In the "Format Axis" pane, under "Axis Options", set the "Minimum" value to .
- Click on "Vertical (Value) Axis" and select "Format Axis" from the drop-down menu.
- In the "Format Axis" pane, under "Axis Options", set the "Minimum" value to .
- Now, both the primary and secondary axis will start from 0 and align at the zero point.
If the above steps don't work, you can try changing the chart type to a combination chart. Here's how:
- Select the chart and go to the "Design" tab in the ribbon.
- Click on "Change Chart Type" and select "Combo" from the drop-down menu.
- In the "Combo" pane, select the "Line" chart type for the primary axis and the "Column" chart type for the secondary axis.
- Click on the "Line" chart type and select "Secondary Axis" from the drop-down menu.
- Click on the "Column" chart type and select "Primary Axis" from the drop-down menu.
- Now, both the primary and secondary axis will start from 0 and align at the zero point.