I have been working on a Crystal Reports report with a line chart for many hours now. It sure does seem like I should probably suppress printing of the chart if there are more than about 25 lines in the chart. Otherwise, the legend overwrites the chart. The chart is worthless without a legend; data labels within the chart are just as bad (obscured and overwritten.) This chart was supposed to show a retail trend analysis, covering hundreds of products in a store. I expect the chart lines to be very crowded and overwritten; the few retail items that break from the pack are the ones of interest to the store owners, in comparison to all the ones clustered together.
Am I simply asking too much of any chart, or is it just the charts in Crystal? I found the company that wrote the charting DLL used in Crystal, and they sell an "enhanced charting library." But, I'm skeptical since the one I have doesn't seem too hot.
If I don't get some help I'm going to use my home lobotomy kit! (as if Crystal wasn't enough by itself)
Tutorials for a crowded chart? Ideas beyond shrinking the fonts in the legend using the Chart Analyzer? Something to make the sting of George W. Bush's win go away? (I know there's not enough points for that!) Any way to show all the lines but only show a subset of the items in the legend? Or maybe print the legend on a separate sheet?