Data Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

k f h - 24 Oct 2006 14:51 GMT

Hi All,

Is it possible to display the Data Table on a Pie chart, as you can in a Bar
chart.

Excel 2003.

Thanks,
kfh.

Reply to this Message

Andy Pope - 24 Oct 2006 15:36 GMT

Hi,

Simple answer, no.

Instead create your own. For more information see Tushar's page,
http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

Cheers
Andy

> Hi All,
>
[quoted text clipped - 5 lines]
> Thanks,
> kfh.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

k f h - 24 Oct 2006 18:30 GMT

Hi Andy,
Thanks for the link, is there any way to add the legend as well.

kfh.

> Hi,
>
[quoted text clipped - 15 lines]
> > Thanks,
> > kfh.

Reply to this Message

Andy Pope - 24 Oct 2006 19:38 GMT

You could create another copy of the chart and reduce the plot area to
as small as possible and place the legend over it. Size the legend and
chart to suit your cells which are acting as the table.

Cheers
Andy

> Hi Andy,
> Thanks for the link, is there any way to add the legend as well.
[quoted text clipped - 20 lines]
>>>Thanks,
>>>kfh.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message