Oct 26 2020 04:13 AM
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
Oct 26 2020 04:56 AM
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.
Oct 26 2020 05:24 AM
@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.