stacked bar charts

[Mark]

I'm am trying the create a stacked bar chart can't seem to
get it to work. any suggestions appreciated. here is an
example of my data. I will have multiple causekeys for
each causecode.


CAUSECODe CODECOUNTS CAUSEKEY KEYCOUNTS
DAT 15 WER 14
NDC 1
APC 11 WER 7
ANA 2
DES 1
TBL 1
JCL 9 WER 8
ITD 1


thanks in advance.

 

[Jon Peltier]

Mark -

If that is a pivot table, drag the CauseKey field to the Column area,
then make a Pivot Chart from the table.

If it isn't a pivot table, fill in the blanks:

CAUSECODE CODECOUNTS CAUSEKEY KEYCOUNTS
DAT 15 WER 14
DAT 15 NDC 1
APC 11 WER 7
APC 11 ANA 2
APC 11 DES 1
APC 11 TBL 1
JCL 9 WER 8
JCL 9 ITD 1

Now make a pivot table, with Cause Code in the Rows area, Cause Key in
the Columns area, and Sum of Key Counts in the Data area, and generate
your chart from the table.

- Jon