Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
column charts with multiple data sets
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
column charts with multiple data sets
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. -- Thanks, Shane Devenshire "Dave Shultz" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Re-Ordering Data Sets in Charts | Charts and Charting in Excel | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Multiple Data Sets | Excel Discussion (Misc queries) | |||
Column charts with multiple data in each column | Charts and Charting in Excel |