If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
follow up: stacked charts
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. |
#2
|
|||
|
|||
follow up: stacked charts
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. -- Echo [MS PPT MVP] http://www.echosvoice.com presenter, PPT Live '04 Oct 10-13, San Diego http://www.powerpointlive.com "Anna Krieger" wrote: 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. |
#3
|
|||
|
|||
follow up: stacked charts
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 Anna Krieger wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|