Excel Chart with multiple data points & chart types

[Rajesh Soni]

I need to create a chart in excel (using 2007version) with following data set

1. Monthly Data
a) Actuals
b) Budget
c) Last year actual

2, YTD(Year to date) Data
a) Actual
b) Budget
c) Last year Actual

The Last year data (YTD and Monthly) should be shown by way of area chart.(in the background)

The Current Year Actuals (Monthly) should be shown by way of Column chart along with Variation from Budgeted numbers (Delta Chart)

The YTD Actual and Budget numbers to be shown through Line chart.

So, Essentially we need to converge these three chart requirements into a single chart.

Would appreciate if you could please help me build the above chart.

Thanks
Rajesh Soni

 

[NARAYANK991]

Hi Rajesh ,

Please upload a workbook with the appropriate data for all the above charts.

Narayan