Good morning everyone, this is my first post here so please be gentle and apologies for any noob questions.
Ok, I have 2d stacked bar chart that at present looks a bit like this:
CATEGORY x
CATEGORY xxx
CATEGORY xxxxx
% (broken down into 6 sections)
However, I would like this be pyramidal - so rather than hugging the y axis, the y axis is central and the data is spread around this central axis.
I have attempted dividing the data in two and using +/- values but unfortunately, the 6 sections need to be kept together rather.
Is this possible in excel as it has been driving me mad! Even if anyone has any ideas how I could achieve this pyramidal effect, that would be great.
thanks all.
can you post example workbook with what you have so far.
Maybe include a picture of what you require using autoshapes.
Will do..hang on a moment.
Right, please find attached.
Apoplogies for the dodgy design of what I would like the chart to resemble!
I think I have to create a tornado chart of some sort...but I am finding this difficult to align the data series around the axis.
Yes tornado or population pyramid is what the chart type is usually called.
This will center each bar against the longest one.
Of course the horizontal scale is now not much use except for reading the last set of data.
Yes the horizontal is rendered a little useless but as you say, the base data set gives something to compare to...as long as the proportions stay the same and are centred, then that's grand!
Now I have to try and work out what you did!
Cheers Andy, you are a star and potentially saved my desk from destruction through headbutting!
Oh I see what you have done, inserted a dummy padding number...simple but genius and I can't believe I didn't figure that out myself!!!
Legend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks