Excel pie chart - data table

crossy75

unread,

Feb 2, 2010, 10:56:47 AM2/2/10

to

Hi all,
I have a simple pie chart, and on it i want to show a data table with
the values on it - obviously can show values on the pie labels however
would like a table on the chart showing the categories and values.

does anyone know how this is possible

regards

Simon

Bob Greenblatt

unread,

Feb 2, 2010, 11:13:15 AM2/2/10

to

On 2/2/10 10:56 AM, in article
48337eaa-ef09-4f19...@f11g2000yqm.googlegroups.com,
"crossy75" <sjc...@yahoo.co.uk> wrote:

Why don't you "take a picture" of the data area with the camera tool and
paste it on top of the chart.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

crossy75

unread,

Feb 3, 2010, 4:42:08 AM2/3/10

to

On 2 Feb, 16:13, Bob Greenblatt <b...@nospam.com> wrote:
> On 2/2/10 10:56 AM, in article

> 48337eaa-ef09-4f19-a622-a1cbc330c...@f11g2000yqm.googlegroups.com,

>
> "crossy75" <sjc5...@yahoo.co.uk> wrote:
> > Hi all,
> > I have a simple pie chart, and on it i want to show a data table with
> > the values on it - obviously can show values on the pie labels however
> > would like a table on the chart showing the categories and values.
>
> > does anyone know how this is possible
>
> > regards
>
> > Simon
>
> Why don't you "take a picture" of the data area with the camera tool and
> paste it on top of the chart.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

thanks, a bit messy as the pie chart will regually update, thus need
to copy paste macro to put table on it - is do able though!

Bob Greenblatt

unread,

Feb 3, 2010, 12:41:36 PM2/3/10

to

On 2/3/10 4:42 AM, in article
b072846f-b0a4-4660...@3g2000yqn.googlegroups.com, "crossy75"
<sjc...@yahoo.co.uk> wrote:

The "picture" taken with the camera tool will also update when the data
changes.

CyberTaz

unread,

Feb 3, 2010, 3:20:13 PM2/3/10

to

Are you using Excel 2008? [It's always important to specify version.]

If so, select the chart then go to the Formatting Palette's Chart Data
group, open the Data Table list & select either of the 2 options.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 2/3/10 4:42 AM, in article
b072846f-b0a4-4660...@3g2000yqn.googlegroups.com, "crossy75"
<sjc...@yahoo.co.uk> wrote:

Lippold...@officeformac.com

unread,

Feb 10, 2010, 7:04:37 AM2/10/10

to

Hi Bob,
Thanks for this suggestion. I have the same problem as above. When I do as you say, with the chart selected I go to formatting palette, chart data section, but then the data list button is shaded and no options are available by clicking. Any suggestion as to how to get the formatting palette to activate the data list options?
Thanks, in advance,
Lippoldtskivich

Lippold...@officeformac.com

unread,

Feb 10, 2010, 8:21:00 AM2/10/10

to

Okay, I've figured it out. To have the values and the category name display in a pie chart, you have to first of all realise that the format data series command does not contain this option. So, select the chart, then click on the format data series option, then click on "category name" (do not select "category name and percentage", which does not display the value, but rather the % share of the total, and also rounds the % in a strange way subtracting a point from the highest category to make things add up!). Then select the chart and right click, then click on "select data", then "select category x labels", and then highlight and select the names AND the values you wish the label to display. This works fine, but it is not at all obvious!

Cheers,
Lippoldtskivich

CyberTaz

unread,

Feb 10, 2010, 9:28:31 AM2/10/10

to

Glad you got it figured out, but this is different from the original post...
The OP wanted to add a Data *Table*, you're adding Data *Labels* :-)

Regards |:>)

Bob Jones
[MVP] Office:Mac

On 2/10/10 8:21 AM, in article 59bb2...@webcrossing.JaKIaxP2ac0,