EXCEL : HOW TO CREATE "CROSS" CHARTS

[zetpap]

I don't know how they're called exactly but I want to create a grid chart that looks like a cross (+) and data emerges from left, right, up and down. Does anybody know how this is done?

Thanks everyone
zetpap

http://zetpap.topcities.com

 

[Hasit]

Not sure you can do this in a snigle chart. You may need to build up the entire picture using multiple charts (i.e. one chart for each quadrant).

 

[Guest_imported]

If I understand your question right, then yes, you can do it with a little bit of trickery. You need to draw a stacked chart and then change the colours of the individual stacks to achieve what you desire.

Another way may be to plot area charts that will give you the same result.

HTH

Indu

 

[zetpap]

Thanks everyone but I really don't know what a stacked chart is.

Thx again for all your help
zetpap

http://zetpap.topcities.com

 

[SkipVought]

A stack chart is a bar chart with the bars stacked. If you format you data properly and format the bars of the chart with either fill or no fill, I could see how such a technique could be achieved. Skip,

 

[Guest_imported]

If there is a way to e-mail you, I could send an example.

Indu

 

[SkipVought]

sure....

skipandmary1017@mindspring.com

Skip,

 

[zetpap]

zetpap@hotmail.com

Thanks again

http://zetpap.topcities.com