Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Legend on Graph

Status
Not open for further replies.

smut

Technical User
Nov 15, 2001
10
GB
Hi,

How do i format a legend label on a graph?

Cheers
 
Right mouse click on the chart and there should be something in your drop down menu called, "Analyzer". This will pop up a new tab where you may be able to fix these labels. Did that help?
 
By the way, you must be in the preview mode to get this Chart Analyzer option.
 

Unfortunatly not. I am trying to format the actually description in the legend. There doesn't seem to be an option to adjust these settings.
 
Well, I created a chart and tried to format the legend label. You just want that label to be edited as you would an Excel chart right? I have been unsuccessful in trying, but if I do figure it out I will be sure to post the way to do it. Sorry :(
 
Thank you for your help/effort, it is much appreciated.
 
i have changed the group description by right clicking on group header then change group options and use an if then else formula . my problem is that this description reverts when i export it. any help is greatly appreciated
 
To change the legend labels, I create a formula with a descriptive formula name and plot it on the graph.

For example, let's say that I would want to plot the count of a field named {tableName.myId} and I would want the label "Count of Ids" in my legend.

I would first create a formula named "Count of Ids" and in it I would write Count({tableName.myId}). Then, I would plot that formula in the chart, and the legend label would be "@Count of Ids". It's impossible to get rid of the "@", though.

Hope that helps!
 
Hi Smut,

I don't use the "built in" legend much. I create my own legends using "Text Boxes" which I can format anyway I want. Then I just place them on the graph.

Nuffsaid.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top