Stacked Bar Chart with a line chart

[taylo40]

Hello,

Have an Excel charting question.

I have a Spreadsheet that looks like:-

Column A = This shows the month
Column B = This has the budget for Dept A' for that month
Column C = This has the budget for Dept B' for that month
Column D = This has the total expenditure for the month

Required
========
What I would like is a stacked bar showing the budget (Dept A + Dept B) for the month

I would then like a line showing the expenditure for the month

Any advice ?

Regards,


Jamie

 

[SkipVought]

Hi,

First format as stacked column.

Then select the series in the chart that corresponds to the expenditures.

With that series selected, change the Chart Type to LINE.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[taylo40]

Thanks Skip,

Jamie