comparison charts - stacked graphs

[ehpando]

Wondering if you could help...
I'm looking at charting two measurements in one chart....the stacke
columns would preferably be side-by side, within the specific dates..


Total 30-Apr-04 7-May-04
0-30 Past Due 4,666 2,361
31-60 Past Due 293 974

60 Past Due 3 3

Excluding NFLD
0-30 Past Due 2,627 1,201
31-60 Past Due 293 524

60 Past Due 3 1

In other words, "Total" would have a stacked column for April 3
showing 0-30, 31-60, and >60 past due and right next to it Excludin
NFLD would have a stacked column (for comparison)..then space..then Ma
7 (two stacked columns).....

Is this even possible? Will this have to be done in pivot tables

 

[Debra Dalgleish]

Set up the data like this:

0-30 31-60 >60
30-Apr-04 Ex NFLD 2627 293 3
Total 4666 293 3
7-May-04 Ex NFLD 1201 524 1
Total 2361 974 3

Then select the range of cells, and create a stacked column chart.