Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Does anyone know how to create a stacked chart with clustered data? I have 5
products that have promotion and sales budgets. I would like to stack the promotion and sales budget and cluster the products for each year (8 total). Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Hi,
Have a look at http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy Pippo24 wrote: Does anyone know how to create a stacked chart with clustered data? I have 5 products that have promotion and sales budgets. I would like to stack the promotion and sales budget and cluster the products for each year (8 total). Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Jon Peltier provides clear step-by-step instructions on how to create a
clustered-stacked chart he http://peltiertech.com/WordPress/clu...column-charts/ -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Pippo24" wrote: Does anyone know how to create a stacked chart with clustered data? I have 5 products that have promotion and sales budgets. I would like to stack the promotion and sales budget and cluster the products for each year (8 total). Thanks |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Andy,
I'm thinking that maybe a stacked chart would work with what I'm trying to do in 2007. I have two sets of data one from Jan 2009 through May, The other data runs from June through November 2009. I need two lines that will plot the first one and the second data. For some reason the second data is also protting the Jan 2009 through May. It doesn't make sense. Any ideas? Dpingger "Andy Pope" wrote: Hi, Have a look at http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy Pippo24 wrote: Does anyone know how to create a stacked chart with clustered data? I have 5 products that have promotion and sales budgets. I would like to stack the promotion and sales budget and cluster the products for each year (8 total). Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info . |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting
Not sure what this has to do with the original post?
If your data is in separate columns and the sections without data are blank then the lines should only plot the relevant data. Series1 Series2 J <value <blank F <value <blank M <value <blank A <value <blank M <value <blank J <blank <value J <blank <value A <blank <value S <blank <value O <blank <value N <blank <value Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "DPingger" wrote in message ... Andy, I'm thinking that maybe a stacked chart would work with what I'm trying to do in 2007. I have two sets of data one from Jan 2009 through May, The other data runs from June through November 2009. I need two lines that will plot the first one and the second data. For some reason the second data is also protting the Jan 2009 through May. It doesn't make sense. Any ideas? Dpingger "Andy Pope" wrote: Hi, Have a look at http://peltiertech.com/WordPress/clu...column-charts/ Cheers Andy Pippo24 wrote: Does anyone know how to create a stacked chart with clustered data? I have 5 products that have promotion and sales budgets. I would like to stack the promotion and sales budget and cluster the products for each year (8 total). Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D Charting | Charts and Charting in Excel | |||
I need help charting | Charts and Charting in Excel | |||
Charting help! | Charts and Charting in Excel | |||
Charting help! | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |