How to add missing week columns to a chart

[nicolaeman]

I have a report for which the grouping of the data based on the week number (1 to 52) doesn't return all of the week numbers based on the select statement criteria.

Question: how can I have all the weeks (1 to 52) in the chart?

Thank you.

 

[SkipVought]

Hi,

Change the chart x-axis from a Category to a VALUE axis.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[nicolaeman]

Sorry but do I change the x-axis to a value from a category?

Thank you.

 

[chelseatech]

It is a different chart type. instead of a bar or line chart use "Numeric Axis" chart type inside the Chart Expert.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[nicolaeman]

I can't find this chart type in Crystal 8.5; are you sure that is available in 8.5? How can I recognise it?

Thank you.