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

Crystal Reports - Creating a Pie Chart

Hello,

I have selected a range of columns in Excel and created a crystal report.  I have summed a few of the columns in Crystal and wish to create a pie chart of those fields.  I am having problems though.

Here is an abrieviated list of what I am trying to use for the chart:

1) Count of Column called "Assessment Number" = 608 - This tells me the number of applications assessed
2) An equation based off of "count of total number of applications - # of applications assessed" which give me the total number of applications not assessed = 2400

I now want to creat a simple pie chart showing the two numbers (608 and 2400).

Within Chart expert, I add these two fields to the "show values" area; but what do i put in the "on change of record" area?

Thanks in advance for the help.  I am new to Crystal so you will see a lot of me around here for a while!

John
0
jz1english
Asked:
jz1english
1 Solution
 
DataSenserCommented:
I don't think you can plot 2 seperate measures in a pie chart so you will need to rearrange your data.  If you devise some kind of indicator (maybe based on the existence of an Assessment Number) you could add the count of application to the "show values" area and put the indicator in the "on change of record" area.

HTH,
DS
0
 
martinez719Commented:
On change of record applies more to a database record.  Can you leave it blank?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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