Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
anson
 
Posts: n/a
Default setting the radius of a pie chart

is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?

i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi anson,

You will need some code to help with this.
Have a look at the example.
http://www.andypope.info/ngs/ng34.htm

Cheers
Andy

anson wrote:
is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?

i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.


--

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
Setting custom chart causes plot area to collapse Chiara Charts and Charting in Excel 0 January 20th 05 06:32 PM
Trouble setting total for on chart Mark Charts and Charting in Excel 1 January 11th 05 03:21 AM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 06:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Setting up data to create a chart George Murray Excel Worksheet Functions 0 November 8th 04 05:33 PM


All times are GMT +1. The time now is 01:47 PM.

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

About Us

"It's about Microsoft Excel"