X Axis Labels
Hello Experts,
We are trying to make a chart in Crystal Reports, that will show the number of operations in our application. We have the following data as input for the report:
- Time
- Count
Time is changed every minute and count is the number of operations for this minute. We always send exactly 1440 records (24 hours x 60 minutes).
We show the graphic in a line chart but the labels on the X axis (showing the time) will appear only if we show 1 hour only and they are really a lot. We want to show only the whole hour values (so 0:00 1:00 2:00 etc.). We tried with chart->right click->Format Chart->Grid->Group Axis->Labels->Use manual number of groups to put there 60, but it does not allow to set more than 3 in this field.
Our chart data is set as following:
chart->right click->Chart Expert->Data->Layout: Advanced (the rest are grayed)->On change of Time show Count
If you need further information I will supply it immediately.
Thanks in advance.
TheAvenger
We are trying to make a chart in Crystal Reports, that will show the number of operations in our application. We have the following data as input for the report:
- Time
- Count
Time is changed every minute and count is the number of operations for this minute. We always send exactly 1440 records (24 hours x 60 minutes).
We show the graphic in a line chart but the labels on the X axis (showing the time) will appear only if we show 1 hour only and they are really a lot. We want to show only the whole hour values (so 0:00 1:00 2:00 etc.). We tried with chart->right click->Format Chart->Grid->Group Axis->Labels->Use manual number of groups to put there 60, but it does not allow to set more than 3 in this field.
Our chart data is set as following:
chart->right click->Chart Expert->Data->Layout: Advanced (the rest are grayed)->On change of Time show Count
If you need further information I will supply it immediately.
Thanks in advance.
TheAvenger
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, Crystal's graphing capabilities have always (IMHO) been lagging behind the standard. They get a little better with each version, but still not where they should be.
Ideally you should be able to use one data set for "on change of" and another field (formula) for the value to show but CR simply doesn't support it...
Ideally you should be able to use one data set for "on change of" and another field (formula) for the value to show but CR simply doesn't support it...
ASKER