Column charts

Q

Questions

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
 
D

Del Cotter

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
 
D

Del Cotter

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top