Use of Secondary Axis

[ellistyle@gmail.com]

I have several horizontally oriented charts in a simple dashboard sheet. In some cases there is only one data series. Is there a way to duplicate the primary axis markers in the secondary axis.


Alternatively, is there a way to display the axis markers to the secondary axis when there is only one data series in the chart?

 

[Hui]

I don't believe you can have a secondary axis without a second set of data

So just copy your first set of data and add another series to the chart

It will be ontop of the first series, set it to the secondary Y axis