Category name in pivot chart

**hapachris** · 07-01-2009, 03:57 AM

I'm trying to change the name of the category name in a pivot chart.

I have pivot table where I summarize some values from a table. I than created a chart out of this pivot table. The chart type is a pie-of-pie chart.

The first pie consists of 2 values "true" and "false". The 2nd pie is a break-down pie of the "true" pie slice.
When the chart is generated, it shows "Others" in the 1st pie. But I want to change this name to "true".
How am I able to do it?
Any help would be appropriated and thanks in advance!

The outlined part is the part I want to change.

http://img4.imageshack.us/img4/5191/pic1qep.jpg

**Andy Pope** · 07-01-2009, 05:20 AM

The text for the 'Other' data label is automatic.

You can however change the text either manually or with code.

Sub ChangeOthersDataLabel()
    
    Dim lngIndex As Long
    Dim strNewText As String
    
    strNewText = "My Label"
    With ActiveChart
        With .SeriesCollection(1)
            .DataLabels(.Points.Count).Text = strNewText
        End With
    End With
    
End Sub

**hapachris** · 07-01-2009, 06:14 AM

Thanks for your help.

Unfortunately I'm not very good in coding.
When I try to manually overwrite "Others" to "true", somehow all the other category names are changing to "true" as well.

**Andy Pope** · 07-01-2009, 07:42 AM

can you post example file?

**hapachris** · 07-02-2009, 05:17 AM

Hello Andy Pope.
Thanks for your help!
I found a work-around. When I import the pivot charts to PowerPoint, I can manually overwrite the category names, without changing all the other names as well.

Thread: Category name in pivot chart

Thread Tools

Display

Category name in pivot chart

Re: Category name in pivot chart

Re: Category name in pivot chart

Re: Category name in pivot chart

Re: Category name in pivot chart

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions