follow up: stacked charts

[Anna Krieger]

Unfortunately, I may have managed to be unclear in my
question posted earlier; I'll try to clarify.
I'm dealing with four data sets:
ex East, West, North, and South
and wanted to get a chart where East and West would be
stacked together in one bar, next to north and south,
which would also be stacked together in their own bar.
So that's: one bar containing east and west stacked. a
second bar containing north and south stacked.
Ideally, I'd like the two bars to be right next to each
other, but that may be a simple formatting issue.
My data goes all the way through column J. [not sure if
that matters]
If you had any further advice, I'd greatly appreciate any
help you can give me.

 

[Guest]

Ah, yes, I did misunderstand your original post.

I'm not sure that what you want can be done in PPT. Off the top of my head, the only thing I can think of is to ungroup the chart and move the data so that the appropriate columns overlap.

It may be possible to do this in Excel, but again, off the top of my head, I'm not sure how, so I can't give you specific steps. Perhaps one of the Excel MVPs will be along with good ideas.

If I get some time in the next couple of days, I can try to play with it, but you might want to post in Excel.Charting newsgroup in the interim. You'll probably get better, more definitive answers there.

Excel charts can be formatted to look like your PPT charts and imported easily into PPT. But the charting engine's available features are much more powerful in Excel.

 

[Andy Pope]

Hi Anna,

It can be done in a couple of ways, depending on whether you want to
mess with combination charts or manip your data values.

I have posted details and a example on my site.
http://www.andypope.info/ngs/ng28.htm

If you have a problem post back.

Cheers
Andy

Unfortunately, I may have managed to be unclear in my
question posted earlier; I'll try to clarify.
I'm dealing with four data sets:
ex East, West, North, and South
and wanted to get a chart where East and West would be
stacked together in one bar, next to north and south,
which would also be stacked together in their own bar.
So that's: one bar containing east and west stacked. a
second bar containing north and south stacked.
Ideally, I'd like the two bars to be right next to each
other, but that may be a simple formatting issue.
My data goes all the way through column J. [not sure if
that matters]
If you had any further advice, I'd greatly appreciate any
help you can give me.