Combination & Stacked chart

**BakerD** · 03-09-2009, 07:11 AM

Hi There,

Am wondering if i can create a combination graph that also uses stacked columns?

I have 2 data ranges which I would like to combine, and a third forecasted range of data that i would like to plot as a line to allow me to see how close the forecasting is to the actuals. Is there any way of doing this?

Example Data

Forecast
Jan 5
Feb 3
Mar 2
Apr 4

prelim Booking
Jan 2
Feb 1
Mar 1
Apr 3

Paid Booking
Jan 2
Feb 1
Mar 2
Apr 0

So I would like to stack the bookings, and then plot the forecast as a line if poss...

Any help with this would be great!

Cheers,
Dave

**Andy Pope** · 03-09-2009, 07:30 AM

Create a stacked column chart on all 3 data series.
The select the forecast series and change the chart type to Line

It would be easier if you could change your data lay out, see attached.