Column charts

  • Thread starter Thread starter Questions
  • Start date Start date
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
 
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
Click to expand...

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
 
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
Click to expand...

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.
 
Back
Top