How to display Y axis scale on both ends of the graph??

[chmura]

I want the units displayed at BOTH ends of the graph and not just on the LEFT side. I want the units display both LEFT and RIGHT sides of the graph.

I'm going crazy because I thought it would be simple to do this.

Thanks!

[teylyn]

Hi,

try this:

add a new column with dummy data to your data table, numbers don't matter
add this new data to your chart
select the new data series and open the format dialog
on the Axis tab select "secondary axis"
now you see the second y axis on the graph
set all the values for your new dat series to zero, so they don't show
format the secondary axis to have the same scale and marker settings as your primary axis
delete the new data series from the legend.

does that help?

[zbor]

Maybe is easier to create on more column wich will be equal as original data (Data is in B column, C column =B1 etc)

Now you will get two overlaping lines. Right click on it -> Format data series -> Secondary axis