Editing Chart Legend Text

Hi Experts,

Is there anyway to edit the text on the legend of a bar graph?
Right now the legend is saying "SumOfCharges". I need to edit this to say "Charges". Any ideas?
If this is not possible, is there any workaround so that I can do something like this?

I'm using crystal report 8.5

Thanks,

yorge
yorgeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

frodomanCommented:
These is no way in Crystal itself to do this.   The workaround is to suppress the legend completely and simply add static text boxes to the report yourself for the legend.

There are some 3rd party plugins that allow you to edit the legend but nothing free that I know of.

HTH

frodoman
0
ebolekCommented:
1. right Click on chart
2. Select chart expert
3. Select text tab
4. Write the new title in the title

These are the things that you can change in a chart.

Regards
Emre
0
ebolekCommented:
Also you can try this to chnage the legend of the chart
Changing the chart's legend text
On the Preview tab, click the text in your chart's legend to select it.
Tip:    Be sure to select the text and not the entire legend.

Right-click the legend text and select Edit Axis Label from the shortcut menu.
In the Label Aliasing dialog box, add the text you want to see in the Displayed Label field.
Click OK.
Regards
Emre
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

yorgeAuthor Commented:
Hi All,

Thanks for the reply.

ebolek : It seems I can't follow the suggestion you have on your last post. Are you sure I can do this with CR 8.5?

How about the label on the base (horizontal labels for bar chart). Is it possible to display this vertically instead of displaying it horizontally? This way I can save some space in the event there will be more bars that will be displayed.

yorge
0
ebolekCommented:
The example I gave is for Crystal 10 version but older versions must be similar to this as well.

You can move the text where ever you want and align the width so that the text becomes vertical also in the chart expert you should be able to set the alignment of the text to vertical too

Regards
Emre
0
frodomanCommented:
Emre,

Actually the function you describe is new to CR10 and didn't exist in older versions.


yorge,

I'm sorry to say my initial answer is still accurate.  You can't do this w/out buying a 3rd party tool or upgrading your version of Crystal.


frodoman
0
yorgeAuthor Commented:
Hi frodoman,

Thanks for the info.
How about my question above about:

"How about the label on the base (horizontal labels for bar chart). Is it possible to display this vertically instead of displaying it horizontally? This way I can save some space in the event there will be more bars that will be displayed. "

yorge
0
frodomanCommented:
As far as I know there's no way in 8.5 to do this - Crystal places the labels automatically.

As you're seeing, the charting capabilities of Crystal aren't very flexible!  If you're interested in a 3rd party plug-in for charts here's a link to the one that I use and am happy with ( http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp ).  It runs about $500 though so you'd have to determine how important the charting issues are and if they're worth spending the money.

frodoman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yorgeAuthor Commented:
Hi frodoman, how about in crystal reports 9 and 10? Is this capability already there now?
0
ebolekCommented:
As I said before

The example I gave is for Crystal 10 version
0
frodomanCommented:
It's in CR10, not in 9.
0
ustesCommented:
It is a shame that you can't edit the text in the legend.  I came here to see if someone figured that out yet.

To Change the rotation of text in 8.5 goto the Chart Analyzer, select the text in the axis, then choose the selected item.  From here you can change the rotation of the text.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

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.