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

EDIT AXIS LABEL

I am trying to change my legend from the field names. I right click and change to my custom label, and rerun the report - perfect. works... But if I run the report with new parameters - now the legend reverts back to the field names again.

How do I make it work for all?
0
NikkiLovesData
Asked:
NikkiLovesData
  • 2
1 Solution
 
mlmccCommented:
Try building a formula to convert the field to the name you want then graph on the formula field

mlmcc
0
 
NikkiLovesDataAuthor Commented:
I do not understand how that will help. Formula fields start with @. THe legend would show sum of @fieldname. i.e.

sum of @cost1
sum of @cost2
sum of @cost3

want it to be:
cost1
cost2
cost3


This is not a group. Each field is a different field of a record.

0
 
Dan WeingartAuthor / CRChartCommented:
I don't recommend this, as it is a really cost-ineffective solution, but you should at least put in the back of your mind the knowledge that our CRChart add-in would solve this issue. The @ASL macro is parsed after Crystal does its work so it is guaranteed to maintain your user-defined legend labels.   Hopefully someone here will give you a free and easy way to accomplish what you want.

-Dan @ 3D

disclaimer: I work for the company, threedgraphics.com, that makes this product. This product costs money.
0
 
NikkiLovesDataAuthor Commented:
I found the solution.
Once you right click and change the data label - click out to highlight the entiore chart again. Then right click, pick Apply to all charts.

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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