Notifications
Clear all
Excel Dashboards
3
Posts
2
Users
0
Reactions
68
Views
Topic starter
I have prepared a pyramid chart from data similar to that used in the course material but have quite a few countries where there are no values for either the male or female. When the country is selected it causes the central axis to jerk to the right or left dependent upon what is missing. Is there a way that I can format the source data so that the central vertical axis remains in place and it is just the values that move? You pyramid axis appears to stay in place. Thanks
Posted : 22/03/2018 11:46 am
Hi Gary,
You could add a dummy series to your chart and set the colour to no fill so it can't be seen as described here: https://www.myonlinetraininghub.com/fix-excel-chart-axis-with-a-ghost-series
Mynda
Posted : 22/03/2018 7:51 pm
Topic starter
Superb. That worked a treat. Thanks Mynda
Posted : 23/03/2018 9:18 am
