How to add category onto secondary axis

[kieran815]

Hi, 

So as you can see in the image below the format from this graph is bad for reading data from the last 3 categories. 

Does anyone know how to add these categories onto a secondary axis? 

I'm finding this almost impossible to do. 

Thanks 

 

[#2]

@kieran815 

It is not possible to plot some categories on a secondary axis, you can only do that for series as a whole.

I'd create two separate charts: one for the first two categories, and one for the other three.

[#3]

@kieran815 If you want excel to display it in one diagram you will need to cheat a bit with the data rows. Add additional rows that only contain the High Valued data as data rows. These you can easily select to be displayed on the secondary axis.