How to add category onto secondary axis

Question

Hi,&nbsp;&nbsp;So as you can see in the image below the format from this graph is bad for reading data from the last 3 categories.&nbsp;Does anyone know how to add these categories onto a secondary axis?&nbsp;I'm finding this almost impossible to do.&nbsp;&nbsp;Thanks&nbsp;

hansvogelaar · Answer

kieran815&nbsp;
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.

pesibiela · Answer

kieran815&nbsp;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.&nbsp;

Forum Discussion

How to add category onto secondary axis

2 Replies

Resources