Oct 31 2023 11:09 AM
I have a rainfall chart.
I want the primary vertical axis in mm and the secondary in inches. I do not want any data to show for the secondary axis.
I'm sure this was easy in Excel 95 or some version long ago, but with Office 365 I'm failing.
Suggestions please?
Oct 31 2023 01:29 PM
You do need an extra series to create a secondary axis, but it can coincide with the existing one.
See the attached demo workbook.
Nov 01 2023 04:37 PM
Nov 02 2023 05:35 AM
One series is displayed exactly on top of the other, so it completely hides the other one.
Setting one of the series to No Fill, No Line is another way of doing it.