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

--

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.

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.

"Andy Pope" wrote:

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.

.

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

"rename category names" wrote:

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.

"Andy Pope" wrote:

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.

.