LinInDenver
asked on
Crystal Reports 2008 - Graph Help
I have a line graph, which plots two items. One of those items is a "Target" line, but the target needs to change each month (without me going in a moving the line each month).
The graphs work great when there is more than one group returned on the X axis. Unfortunately, my Target line does not appear if only one group is returned on the X Axis.
Graph Configuration: Line Chart, plotting two lines. One of the lines I have formatted the series to display as a Riser.
I have attached my graph configuration, as well as a visual of what I'm trying to do.
graph-issues.pdf
The graphs work great when there is more than one group returned on the X axis. Unfortunately, my Target line does not appear if only one group is returned on the X Axis.
Graph Configuration: Line Chart, plotting two lines. One of the lines I have formatted the series to display as a Riser.
I have attached my graph configuration, as well as a visual of what I'm trying to do.
graph-issues.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi PCIIain - I'll play with it a little bit. I was thinking about "the fudge" as well - I'm just not sure if I can do it predictably with only those with one market.
It is basically a report by Market - some markets only have one location, while others have more than one.
It is basically a report by Market - some markets only have one location, while others have more than one.
ASKER
Hi PCIIain - I'll play with it a little bit. I was thinking about "the fudge" as well - I'm just not sure if I can do it predictably with only those with one market.
It is basically a report by Market - some markets only have one location, while others have more than one.
It is basically a report by Market - some markets only have one location, while others have more than one.
I wouldn't bother, Just have a dud column at the beginning of the graph each time. As long as you don't wind up with too many locations, it'll not make enough difference.
Eg, if this is sales, by salesperson, list all the salespeople even if they have sold nothing in the period?
Then there'd be more than one entry on the X-axis and this problem would be hidden.