Stacked Bar Chart Design Using Multiple Groupings

[Will0857]

I have a set of data. I've grouped that set of data twice. First Grouping is by month, then by Standard.
The Data could be 200 per month and the amount of all the standards will equal the month (standard 1=140, standard 2=40, standard 3=20). whats the best way to represent that visually? i tried two bars per month but Crystal only allowed me to show the total per month as one line and one of the standards (not all the standards) as the other.

 

[SkipVought]

Hi,

If the issue is, like in Excel, where you cannot have both Grouped and Stacked, then...

make your chart type as stacked and add an EMPTY SERIES to the group. It will appear to be Grouped and Stacked.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Will0857]

I don't know how to add an empty series. Am i able to send you a copy of my report so you can walk me through what i need to do?

 

[SkipVought]

South and North as two series with empty DATA.

The x axis must be a category type axis rather than numericly related.
[tt]
South North
Jan '01 189 587
Jan '02 322 398

Feb '01 201 543
Feb '02 344 344

Mar '01 208 513
Mar '02 421 322

Apr '01 266 477
Apr '02 434 309

May '01 301 422
May '02 480 312

Jun '01 316 416
Jun '02 498 302
[/tt]

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Any resolution?

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]