Pivot charts

Hello Kezia

Thank you for your question.
Yes it is possible to have 2 y axis, here's how:

1. create a chart in the usual way.
2. select the data series (e.g. columns) that you want to make into the secondary axis
3. Right and select Format Data Series from the list
4. Click in the Secondary axis check box. The selected columns now appear on top of any other columns.
5. Leave the columns selected and on the Design ribbon, select Change Chart Type.
6. chose a line chart so the other chart data is clearly visible.

Hope this helps.


Kind regards

Cindy
Microsoft Office Trainer