Secondary axis charts

Resolved · Urgent Priority · Version 2010

Fri 12 Aug 2016, 14:23 Delegate Steve said...

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.

Fri 12 Aug 2016, 16:51 Trainer Richard said...

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

Mon 15 Aug 2016, 13:11 Delegate Steve said...

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

Mon 15 Aug 2016, 13:24 Trainer Richard said...

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

Mon 15 Aug 2016, 15:47 Trainer Richard said...

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.

Mon 22 Aug 2016: Automatically marked as resolved.

Training courses