Pie Charts

In my pie chart, items are grouping together as other even though there is no
"other" in my budget -- why? It is actually a cool idea -- how to I add
other items to this "other" (e.g. very small percentages of the pie).

"IDA" <[email protected]> wrote in message
news:[email protected]...
> In my pie chart, items are grouping together as other even though there is
no
> "other" in my budget -- why? It is actually a cool idea -- how to I add
> other items to this "other" (e.g. very small percentages of the pie).

Is this a Pie-of-Pie or a Bar-of-Pie chart?

If so, the data in the small pie or the bar will automatically be added
together to make up a piece called "other" in the main pie.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I guess it is a bar-in-pie chart, but how did Excel choose those line items
to form the "bar" and how to I replace some of the larger percentage one with
smaller ones from the "bigger" pie?

"Echo S" wrote:

> "IDA" <[email protected]> wrote in message
> news:[email protected]...
> > In my pie chart, items are grouping together as other even though there is
> no
> > "other" in my budget -- why? It is actually a cool idea -- how to I add
> > other items to this "other" (e.g. very small percentages of the pie).
>
> Is this a Pie-of-Pie or a Bar-of-Pie chart?
>
> If so, the data in the small pie or the bar will automatically be added
> together to make up a piece called "other" in the main pie.
>
> --
> Echo [MS PPT MVP]
> http://www.echosvoice.com
>
>
>

Double click on one of the pie pieces, then click on the Options tab.
This provides a number of ways to group points into the Other category.
By default Excel groups them by position, with the last N points grouped
in Other (N is the largest integer smaller than half the number of points).

You can also plot by value (e.g., all points less than a value of 50),
or by percent value (e.g., all point less than 10% of the total), or
custom. Custom is pretty cool, because it allows you to drag points from
the main pie to the smaller bar or pie.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


IDA wrote:

> I guess it is a bar-in-pie chart, but how did Excel choose those line items
> to form the "bar" and how to I replace some of the larger percentage one with
> smaller ones from the "bigger" pie?
>
> "Echo S" wrote:
>
>
>>"IDA" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>In my pie chart, items are grouping together as other even though there is
>>
>>no
>>
>>>"other" in my budget -- why? It is actually a cool idea -- how to I add
>>>other items to this "other" (e.g. very small percentages of the pie).
>>
>>Is this a Pie-of-Pie or a Bar-of-Pie chart?
>>
>>If so, the data in the small pie or the bar will automatically be added
>>together to make up a piece called "other" in the main pie.
>>
>>--
>>Echo [MS PPT MVP]
>>http://www.echosvoice.com
>>
>>
>>

Double-click the plotted pie then select the Options tab. Now, change
the settings in the 'Split series by' dropdown and the field below it
(label changes based on selection of first drop down).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I guess it is a bar-in-pie chart, but how did Excel choose those line items
> to form the "bar" and how to I replace some of the larger percentage one with
> smaller ones from the "bigger" pie?
>
> "Echo S" wrote:
>
> > "IDA" <[email protected]> wrote in message
> > news:[email protected]...
> > > In my pie chart, items are grouping together as other even though there is
> > no
> > > "other" in my budget -- why? It is actually a cool idea -- how to I add
> > > other items to this "other" (e.g. very small percentages of the pie).
> >
> > Is this a Pie-of-Pie or a Bar-of-Pie chart?
> >
> > If so, the data in the small pie or the bar will automatically be added
> > together to make up a piece called "other" in the main pie.
> >
> > --
> > Echo [MS PPT MVP]
> > http://www.echosvoice.com
> >
> >
> >
>