Stacked Excel Chart with Additional Column 1

[DeLaMartre]

This one is stumping me. I have two ranges I want stacked on a chart, with an additional range as a column on same chart.

Day DM Other Capacity
Monday 1367 505 1590
Tuesday 1245 472 1526
Wednesday 1147 446 1526
Thursday 1055 525 1526
Friday 896 476 1558

DM and Other are the stacked columns, with Capacity as separate adjacent column.

Any help will be greatly appreciated, as the boss is sitting next to me.

Thanks!




-Bob in California

 

[SkipVought]

Hi,

Set up the stacked column chart first withour the last series

copy the Capacity data range

select the chart - Edit/Paste Special

select the new series - Chart/Chart Type - select LINE

Chart/Chart Options - Axis tab - select secondary

select the new series 0 Chart/Chart Type - select Side by SIde Column

select the series - format series - Options tab and play around with overlap & gap width



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DeLaMartre]

You are the MAN, Skip!

Thanks for your fine expertise.



-Bob in California