Change default pie chart colors and axis labels (CR9)

Hi Experts,

Im using Crystal Report 9 and MS Access.

I am creating a report containing a pie chart.  Can I change the default colors that CR is using?  I also want to change the axis labels.  My pie chart is set for all groups.  What i'm currently doing is editing the axis labels of each pie chart for each group.  I have a pie chart with 5 slices.

Appreciate any help that I can get on this.

Regards.

ann

wala_langAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
ann,

Glad my previous posting was helpful but sadly I can't come to the rescue on your second question:

>>> Whenever I chose a data that was not part of a previous report, it re-sets to its default axis labels.

Unfortunately that's just the way Crystal works and I don't know any way around it.  When Crystal creates a new chart (which is essentially what happens when you add new data) many settings are reset to the defaults.  I've yet to see any way around this.

If Dan3D happens to see this topic he may have a secret workaround (he worked on the actual charting dll's for B.O.) but otherwise you're stuck with manual changes on this one.

frodoman
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
For CR9, right-click on a section of the pie chart and select Chart Options|Selected Item.  One of the options is to change the color for that section of the chart.

~Kurt
0
 
wala_langAuthor Commented:
Hi Kurt,

That's why I'm currently doing but I noticed that when I refreshed the report and it so happened that there are new data, the color goes back to its default value.  I want CR9 to retain the colors that I've chosen.  Same goes with the axis labels.

Regards.

ann
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
wala_langAuthor Commented:
Hi Experts,

I was able to solve the problem with the chart colors.  I was going thru the previous discussions on this site on CR and I came across a suggestion by frodoman.  I did exactly as he suggested and it worked.  

But I'm still left with the problem on axis labels.  Whenever I chose a data that was not part of a previous report, it re-sets to its default axis labels.  I want to retain the label of my choice.

Regards.

ann
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
frodoman's right.  There aren't too many options :(
0
 
wala_langAuthor Commented:
Hi Everyone,

I just created some running total using names that I want to use as labels.  Then I used them as the values for the slices of my pie chart.  Although, I would love to have the number sign (#) removed, but I know that its not possible (?).

Anyway, I'll just award the points to frodoman since it was his idea that was able to solve my problem.

Thanks for all your time =)

ann
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.

All Courses

From novice to tech pro — start learning today.