Column charts
 

I'm trying to create chart where columns are side by side by one of the
columns is stacked. I utilized the information found in Column Chart with a
difference but some information is missing. I was able to get the stacked
column but the information for the second column is not there. What did I do
wrong.

Example:
Jan Feb Mar
Discharges 60 55 20

(Stacked info)
FS 45 44 29
C&FC 6 12 9
Other 0 0 1

Column charts
 

On Wed, 14 May 2008, in microsoft.public.excel.charting,
Questions said:

I'm trying to create chart where columns are side by side by one of the
columns is stacked. I utilized the information found in Column Chart with a
difference but some information is missing. I was able to get the stacked
column but the information for the second column is not there. What did I do
wrong.

Example:
Jan Feb Mar
Discharges 60 55 20

(Stacked info)
FS 45 44 29
C&FC 6 12 9
Other 0 0 1

Don't put your Discharges in the same Excel spreadsheet column as your
stacked info, but put it in a column one cell to the left or right.

Like this:

Jan Feb Mar
Discharges 60 55 20
(Stacked info) FS 45 44 29
C&FC 6 12 9
Other 0 0 1

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Column charts
 

On Wed, 14 May 2008, in microsoft.public.excel.charting,
Del Cotter said:

On Wed, 14 May 2008, in microsoft.public.excel.charting,
Questions said:

I'm trying to create chart where columns are side by side by one of the
columns is stacked. I utilized the information found in Column Chart with a
difference but some information is missing. I was able to get the stacked
column but the information for the second column is not there. What did I do
wrong.

Don't put your Discharges in the same Excel spreadsheet column as your
stacked info, but put it in a column one cell to the left or right.

Like this:

Jan Feb Mar
Discharges 60 55 20
(Stacked info) FS 45 44 29
C&FC 6 12 9
Other 0 0 1


If you're having problems reading the text, try it this way:

Jan Jan Feb Feb Mar Mar
Discharges 60 0 55 0 20 0
FS 0 45 0 44 0 29
C&FC 0 6 0 12 0 9
Other 0 0 0 0 0 1

It's just the same layout with a lot of extra zeroes and Month headings
filled in, but it may solve your confusion.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.