Pivot Chart Category Label

[taw]

Does anyone know if it's possible to change a category label in a pivot chart? I can read the category names, but if I try to change it, I get a message that it is read-only. Maybe I'm missing something simple, but I am making a radar chart and to get it to display correctly, I end up with category labels that say 'Sum of FieldName:' and I want to change these.

Thanks,
Tom

 

[Zigzag]

I've done this with pivot graphs, not sure it will work the same with charts.

If you create a form and then view it as a pivot graph I think it will show the label text instead of the field name. That way you can change the label to whatever you want displayed on you pivot chart.

Garry

 

[Zigzag]

Sorry, got my charts graph and tables mixed up,

It should work OK.

Garry

 

[taw]

Perfect!

Yes, that worked! To clarify what I did: I changed the form to show a Pivot Table instead of the Pivot Chart. Then I could right click on the label and choose properties where I could edit the label (you don't have that option in the chart). Then I changed it back to a chart and it showed the new label.

Thanks a bunch Garry.

Tom

 

[Zigzag]

Hi Tom,

Glad to hear you got it working.

Just one word of caution, If you are thinking about printing the crosstab Graph out then you might run into similar problems to myself.
When it is printed out sometime it comes out as a reverse mirror image.
It tends to happen more when sent to a network printer.
I have never really got to the bottom of it or found a workaround.

Just a heads up,

Garry

 

[taw]

Thanks

I haven't gotten that far yet, but I am going to have to print it out. Thanks for the heads up.

Tom