Print Page | Close Window

Adding Multiple Sum Fields to a Chart

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17374
Printed Date: 02 May 2024 at 6:40pm


Topic: Adding Multiple Sum Fields to a Chart
Posted By: ktram
Subject: Adding Multiple Sum Fields to a Chart
Date Posted: 20 Aug 2012 at 5:44am
Hi,

I'm creating a simple bar chart within a subreport that is based on a group (gift date).  I would like to be able to compare three separate sum fields within the same chart, but it seems to only be letting me add one sum field to the chart.

Is there a way to add multiple sum fields to the same chart for comparison?

Thanks,
Keith


Replies:
Posted By: z9962
Date Posted: 20 Aug 2012 at 11:41pm
You will need to change the graph to an advanced graph
 
1. right mouse click on the chart and select Chart Expert
2. Select Data tab
3. Click the advanced button
4. Select the field that you have grouped and move to the On change of list box
5. Add the fields to be summed to the Show Values list box.
 
Then you are done.
 
Note You can only list 1 on change of field with multiple Values, or multiple on change of with one value...

Posted By: ktram
Date Posted: 21 Aug 2012 at 3:59am
That worked.  Thanks very much!


Print Page | Close Window