column charts with multiple data sets

  • Thread starter Thread starter Dave Shultz
  • Start date Start date
D

Dave Shultz

My data set is below.

I want to show column charts: The first one would be Product A for August
made up of data for versions 1-4, column two would be Product A for September
made up of data for versions 1-4.

The third column would be Product B for August made up of data for versions
1-4, column four would be Product B for September made up of data for
versions 1-4.


Product Version August September
A 1 30,812 365,874
A 2 59,650,018 56,404,138
A 3 29,931,636 28,053,084
A 4 71,972 62,352
B 1 7,094,967 11,718,925
B 2 9,588,255 4,502,779
B 3 424,143 385,699
 
Hi,

I think this will do what you want. Change your data setup to

Month Product Ver 1 Ver 2 Ver 3 Ver 4
Aug A 30,812 59,650,018 29,931,636 71,972
Aug B 7,094,967 9,588,255 424,143
Sept A 365,874 56,404,138 28,053,084 62,352
Sept B 11,718,925 4,502,779 385,699

Select all the data and titles and click the Chart Wizard, Choose Column,
Stacked, (second choice), Click Next, choose Series in Columns. Click Finish.
 
Back
Top