Forum Discussion

Copper Contributor

Oct 26, 2020

How to add category onto secondary axis

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'...

Excel on Mac

office 365

PeSiBiela

Copper Contributor

Oct 26, 2020

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.