#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"