Dual Axis stacked bar.

[Interactive worksheet]

Hello,

Thank you in advance for any and all the help.

I have 4 sets of data. I have:

The date which i want to be on the X-Axis
I have two $ values that i want stacked in a bar chart with the $ number on
the left Y-Axis
And finally i have the % value which will be shown on the right Y-Axis but
as a line chart.

Can this be done and how?

Again, thank you.

 

[Andy Pope]

Hi,

Easiest way is to create a stacked bar chart using the 3 sets of data
and then format the 3rd data series to be on the secondary axis with a
chart style of line.
So for example your 4 sets of data are in the range A113.
B11 contains series names
A2:A13 contains 12 months
B2:B13 contains bottom of stack data
C2:C13 contains top of stack data
D213 contains %Value data

Select the range A113 and create a stacked bar chart using the wizard.
Double click the %value data series and on the axis tab select the
secondary axis. This time right click the %Value data series and change
the chart type to line.

Cheers
Andy