Rajesh Soni
New Member
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
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