View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier[_2_] Jon Peltier[_2_] is offline
external usenet poster
 
Posts: 461
Default Composite Histograms

Check out this tutorial:

Clustered-Stacked Column Charts
http://peltiertech.com/WordPress/clu...column-charts/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



hans L wrote:
A correction on my Question. I meant to say stacked columns, not bars.

"hans L" wrote:

I have the following data that I want to represent in histogram format.
Jan Feb Mar
Budget A 20 22 30
Budget B 8 10 14
Actual A 16 20 32
Actual B 6 6 10

I want to see two stacked bars per month that compare Budgets and Actuals as
follows:

20 16 22 20 30 32
8 6 10 6 14 10
J A N F E B M A R
The numbers above would then be represented by the stacked bars in
corresponding colors.
The best I can come up with is four bars per month but that gets cumbersome
to read. Any suggestions? Thanks for your help.