rename category names

[rename category names]

I have the data in the below format
vendor amount
a 100
b 200
c 300
d 400
Now in the chart i want the category names as a,b,other(c,d should appear as
other). Total amount of c and d should show up for other. Can you please
suggest how this is possible.

 

[Andy Pope]

Hi,

The chart will not summarise or group your data. You do that on the
worksheet using formula then plot the new summarised data.

Cheers
Andy

 

[rename category names]

The data for my pivot chart comes from pivot table. I was able to group the
data using the group option but the problem is it puts c,d in one group and
a,b in another group. So in the chart i see both these groups. Is there a way
i can group only c,d so when i look in the chart the category names appear as
a,b,other.

 

[rename category names]

I was able to resolve the issue.
Thanks a lot.

The data for my pivot chart comes from pivot table. I was able to group the
data using the group option but the problem is it puts c,d in one group and
a,b in another group. So in the chart i see both these groups. Is there a way
i can group only c,d so when i look in the chart the category names appear as
a,b,other.