EXCEL - Multiple "bar chart" from multiple entries of two series each
Example: Showing actual (%) versus projected budget (%) month by month for five projects (A to E) all in same master chart:
1) Overall layout
The master chart is actually divided in five sub charts. Each sub chart has transparent background. They are all grouped and placed over a big black rectangle with gradient fill effect.
2) Data source
Each chart has two series: Actual and Budget, with same Axis label ( = Months)
3) Chart type: overlapping cluster bars
Once plotted, select the charts and select "change chart type" to define format the combo of the two series.
4) Clustered bar width and format
Select and modify the format of each series and set up the width & the series colors and fill you like.
5) Chart titles and axis values
Create text boxes with formula linked to the main table to have the titles and axes updated automatically when you modify the main table.
6) Chart axis
Add white lines with dash to make the axis.
No comments:
Post a Comment