Showing Zero Values in Chart

[btodag]

I'm using Crystal Reports 11 standalone. I have a large dataset that is grouping by customer, then product type. In the Customer and Product type group headers, I'm showing a bar graph showing volumes.

My problem is it skips months with 0 volume. I'm using it to review ordering patterns and to see "missing teeth" kind of thing would be helpful vs seeing only positive volume months.

Any idea on how to do this? My datasource is an excel spreadsheet (I know, I know...). I just love CR to slice through data quickly.

Brian

 

[SkipVought]

hi,

There's a difference between 0 (value) volume and NO (value) volume. From your post, it seems that you have NO volume data for certain months.

Can you change your x-axis from a Category axis to a Date/Numeric axis?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

BTW, that assumes that your Months are REALLY DATES and not just strings.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[btodag]

You're right, thanks for the feedback!!

My dates are in fact dates (at the day level per record), and I'm grouping by month. I'm not sure how to change it to a category axis...

 

[btodag]

I think I found the category axis idea, but it really hoses up my chart.

The odd thing to me is that the overall data has all of the dates that are interesting, but within the group, that subset may not. The chart only shows what the subset has.

BG