ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Table (https://www.excelbanter.com/charts-charting-excel/115851-data-table.html)

k f h

Data Table
 
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.


Andy Pope

Data Table
 
Hi,

Simple answer, no.

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

Cheers
Andy

k f h wrote:
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.


--

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

k f h

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

kfh.


"Andy Pope" wrote:

Hi,

Simple answer, no.

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

Cheers
Andy

k f h wrote:
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.


--

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


Andy Pope

Data Table
 
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

k f h wrote:
Hi Andy,
Thanks for the link, is there any way to add the legend as well.

kfh.


"Andy Pope" wrote:


Hi,

Simple answer, no.

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

Cheers
Andy

k f h wrote:

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.


--

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


--

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


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com