Charting

[Pippo24]

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]

Hi,

Have a look at
http://peltiertech.com/WordPress/clustered-stacked-column-charts/

Cheers
Andy

 

[Luke M]

Jon Peltier provides clear step-by-step instructions on how to create a
clustered-stacked chart here:

http://peltiertech.com/WordPress/clustered-stacked-column-charts/

 

[DPingger]

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]

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