Steve has attended:
Excel Charting course
Secondary axis charts
I am trying to produce my first secondary axis chart. I have achieved this as a bar chart, however, the 2 sets of bars for the 2 different sets of data are sitting on top of the other within the chart. How do I separate them so they appear next to each other. I have selected 'clustered column' in chart type but this is not solving the problem. Changing series overlap or gap width also makes no difference.
RE: Secondary axis charts
Hi Steve,
Click the Chart and go to the Design tab, Edit Data
Can you check for me that the Legend Entries (Series) on the left side has 2 items in it?
If not click ADD
Series Name is the 1 cell that is the Heading above the data
Values is the range of cells you wish to plot
Let me know if that helps.
It could also be the formatting/scale of the Axis.
Do you the 2 data sets have similar figures or is one column significantly larger?
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Secondary axis charts
Hi Richard
Yes I already have 2 items in the legend entries. No the 2 data sets do not have similar figures, however, I have already adjusted the scale for the smaller one.
I can clearly see both data sets' bars in the chart, however, 1 is sitting on top (not above as a stacked column) of each other and I want them to sit next to each other as grouped columns.
Steve
RE: Secondary axis charts
Hi Steve,
Good to know you've checked those things.
Without seeing the data/chart, I'm not sure what else to suggest.
You could send a copy of that Chart to info@stl-training.co.uk for me to have a quick loo at it?
Please remove commercially sensitive data before sending.
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
