Change a Summary Filed's Name

[calandrelli]

I have a summary field that sums a calculated field called "30%". When I make a pie graph of the data the legend calls the data SUM @30%. I wnat to give it another name. Is there a way to change a formula to rename a field?

 

[jbpez]

You could create your own sum of 30% formula and name it whatever you want.

The formula would be something using the following
Sum(field,fieldcondition)

John Borges

 

[calandrelli]

I did that and not thte chart legend shows that it is ploting a field named @30%. It is adding the @ symbol to show it's a calculated field. Is there no way to get rid of it. (version 8.5)

 

[lbass]

I'm guessing you are referring to the chart title, not the legend. Go to the chart expert->text tab->title->uncheck "autotext" and enter the title you would like to appear.

-LB

 

[calandrelli]

I fixed it... I was creating the chart incorrectly.

Thanks anyway