?
Solved

Change default pie chart colors and axis labels (CR9)

Posted on 2004-09-27
6
Medium Priority
?
949 Views
Last Modified: 2010-05-18
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

0
Comment
Question by:wala_lang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12166148
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
 

Author Comment

by:wala_lang
ID: 12166211
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
 

Author Comment

by:wala_lang
ID: 12166404
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
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 12168372
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
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12171258
frodoman's right.  There aren't too many options :(
0
 

Author Comment

by:wala_lang
ID: 12174867
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

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question