Forum Discussion

ChillyAnn's avatar
ChillyAnn
Copper Contributor
Oct 31, 2023

Secondary axis without showing data

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?

Charting
excel

3 Replies

    • ChillyAnn's avatar
      ChillyAnn
      Copper Contributor
      Nov 01, 2023
      Thanks Hans.

      How did you make the second data not show in the chart? I did eventually find the combo chart, but the inch data sat on top of the column of mm data. The only way I could hide it, was to make it no fill, no border. Is that the only way?
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Nov 02, 2023

        ChillyAnn 

        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.

Resources