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 (E-Mail Removed)>
wrote in message news:AA811B64-C28D-490E-A3D7-(E-Mail Removed)...
>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 (E-Mail Removed)>
> wrote in message news:AA811B64-C28D-490E-A3D7-(E-Mail Removed)...
> >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 (E-Mail Removed)>
> > wrote in message news:AA811B64-C28D-490E-A3D7-(E-Mail Removed)...
> > >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.
> >
> > .
> >