Forum Discussion
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...
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?
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?
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.