Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Change default pie chart colors and axis labels (CR9)

Posted on 2004-09-27
6
Medium Priority
?
950 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
What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

 
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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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

636 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