rename category names

  • Thread starter Thread starter rename category names
  • Start date Start date
R

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.
 
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
 
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.
 
I was able to resolve the issue.
Thanks a lot.

rename category names said:
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.
Click to expand...
 
Back
Top