Crystal reports multiple series charting

[Saj]

Hi

I currently have a chart which creates a line chart based on 2 axes (1 x and 1 y-axis) - img: currentChart attached. I am trying to modify this to create img: targetChart attached. i.e. along with the curved chart in the first picture for water content vs dry density, I need to add 3 more series to the chart to create 3 lines - 1 line for each of the Air voids (0%, 5%, 10%). I have not done much charting in crystal reports before, so if anyone can point me in the right direction it will be much appreciated.

I read in this community about creating the charts separately and imposing one over the other using transparency. WIll that work?

I have currently tried setting up the following

Geeta

[Saj]

Hai geetha, please help me on drawing a graph for sieve analysis,multiple line graph in sap crystal report. the below is the graph whch i got from the tables.but the yellow highlighted lines not required to show. means theree lines need to show seperatelt. one line is not joining but the rest of the lines joining back to the starting point. also one seperate line is appearing in the graph.but no idea from where it appearing. please help on this.

[gh_cr05 · Accepted solution]

Hi

I have finally worked out how to do this. I thought i should share it in case someone else needs it.

Essentially i created separate subreports for each X and Y-axis (X-axis is the same for all). So one subreport - chart with Dry Density as the Y-axis - this is the base chart hence has all the grid lines, titles, axes labelled and is Moved to the Back.

2ndly created a subreport which has a chart with Air voids at 0%, only right hand Y-axis title and axis labels, transparent in Chart Expert>Options, no other titles or axes labels to be input, border = white, removed chart frame and x and Y - axis lines so you end up with just the following in your sub report preview for this chart

The remaining 2 air voids are similar to the above but with no axis labels or title - first add the axis labels and preview and adjust all the charts' positions so the axes on the right align correctly and then remove the labels. All of them should have transparent ticked in Chart Expert>Options. And move their positions to be in front of the base chart which is not transparent.

Hope this helps someone.

Regards

Geeta

[former_member670299 · Accepted solution]

Dear Geetha,

Please help me to overcome this issue. see in the picture attached, the Y axis value cuts the top part. Axis value is taking automatically the input value ie;1.80, (X axis-12.9, Y-Axis 1.80). I need to get exact curve for my graph.So is it possible to change the interval from the final value of Y axis or how i can do the same to get the proper graph. In excel can be add the min and max interval.

[Saj · Accepted solution]

hi geetha

[Saj · Accepted solution]

Hai geetha,