andrewpearce
New Member
I built a horizontal bar chart showing the Top 10 Fastest Growing Brands.
- On the category axis I have the brand names.
- On the secondary category axis I have their total volume as labels.
- Series 1 plots the actual growth in litres.
- Series 2 is the % growth. Bars are hidden and I retain only the labels.
It's a bit busy, but the powers that be love it!
The question I have is when I sit this chart on the Bottom 10 Fastest Declining Brands I loose the secondary category axis labels?! Now that I am looking at negative values the bars swing right to left and the labels drop off. I have fiddled and played and am defeated!
Assistance would be much appreciated!
I have a workbook example setup but don't think you can attach .xls files to a post - happy to send through though.
- On the category axis I have the brand names.
- On the secondary category axis I have their total volume as labels.
- Series 1 plots the actual growth in litres.
- Series 2 is the % growth. Bars are hidden and I retain only the labels.
It's a bit busy, but the powers that be love it!
The question I have is when I sit this chart on the Bottom 10 Fastest Declining Brands I loose the secondary category axis labels?! Now that I am looking at negative values the bars swing right to left and the labels drop off. I have fiddled and played and am defeated!
Assistance would be much appreciated!
I have a workbook example setup but don't think you can attach .xls files to a post - happy to send through though.
