• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

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
0
LinInDenver
Asked:
LinInDenver
  • 3
  • 2
1 Solution
 
PCIIainCommented:
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.
0
 
PCIIainCommented:
Alternatively, can you fudge the data to add a single entry for a group where the group field is ' ' and the value is 0 (with the target field set)? Then you'd get a minimum of two bars, but one would have no header and no value....
0
 
LinInDenverAuthor Commented:
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.
0
 
LinInDenverAuthor Commented:
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.
0
 
PCIIainCommented:
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.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now