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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rename category names" <rename category
wrote in message ...
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.