So I'm attempting to create a chart in Excel
I have six Series in the Source Data selected.

I would like to create three stacked bar graphs

Total Sales (one series)
America Sales (two series)
Europe Sales (two series)
Sales Goal (one series)

However when I attempt to use the "stacked column with 3-D visual effect" they all go into the same graph.
When I attempt to change the X axis labels it changes the label for ALL six series, not just the one currently highlighted.

Anybody have an idea what's going on? What's the solution?

11/29/2007 2:29:29 PM

1) in the Source Data window, are you trying to edit your series in the "Data Range" tab or "Series" tab? You should be using the Series tab to get more granular control.

2) what do you mean "they all go to the same graph". Do you want 1 graph with all the data, or 3 graphs?
Are you sure you shouldn't be using "3-D Column" graph instead of "Stacked column with 3-d visual effect"?

11/29/2007 3:07:21 PM

1) Series Tab

2) When attempting to do a stacked column with 3-d visual effect, all the data is placed into one column.
However I need four columns, two with two sets of the series data.

11/30/2007 11:54:14 AM

i'm sorry, but i'm still just not clear on 1) what you're trying to do, and 2) how you're trying to go about doing it.
Can you post a screenshot of your Source Data > Series window?

or, post some sample data in a tabular format, and I can work up a chart and see if that's what you want, then show you how to make that chart

11/30/2007 1:30:21 PM

Each graph is to only one value, each series is that value.... if that makes ANY sense

I want Germany Oct, Nov into one stack
USA Oct, Nov into one stack.

[Edited on November 30, 2007 at 4:11 PM. Reason : Ugh.]

11/30/2007 4:10:09 PM

ok i see, so you want something like this?



I think maybe your main problem is your X-axis labels should be a range (not a single cell) of countries, then you should have one Series for each month, like this:




Also, you could create 3-D graphs like these




[Edited on November 30, 2007 at 4:27 PM. Reason : .]

11/30/2007 4:26:25 PM

Okay, severe problem is that the spreadsheet has two worksheets of data making up this chart, the values needed for this data are all over the chart

Data1
data1
daTa1
datA1

Total1 - in chart

Data2
DaTa2
DatA2

Total2 - in chart

--------- worksheet 2


Data1
data1
daTa1
datA1

Total1 - in chart

Data2
DaTa2
DatA2

Total2 - in chart

11/30/2007 4:36:34 PM

well, in general, charts are easier to make when all the required data is gathered together in a single table. So I would suggest making a third worksheet that uses references or formulas like vlookup to pull the appropriate data from the other sheets into one summary table. Then make a chart out of that summary table.

it also occurs to me that a Combination Graph might be good for what you're trying to do too

11/30/2007 4:39:17 PM