Link to home
Start Free TrialLog in
Avatar of LinInDenver
LinInDenverFlag for United States of America

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
Avatar of PCIIain
PCIIain
Flag of United States of America image

Hmm, would it make sense to alter the graph to show entries on the X axis even if the value if 0?

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.
ASKER CERTIFIED SOLUTION
Avatar of PCIIain
PCIIain
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LinInDenver

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.
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.
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.