LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Craig
 
Posts: n/a
Default Pie Chart with 3 data series?

Hi,

I have a column of 8 labels with 2 columns of data next to it (two numbers
for each label). (one of the data columns contains smaller numbers that
represent a percentage of the other corresponding number in the other column)
I can build a pie chart based on the larger data series so I have 8 slices,
but can I also have the small data series displayed as small line arcs within
each pie wedge to represent the proportion of the smaller number in the
column to the larger number in the other column? The arcs around the inner
center area of the pie would vary, since the percentages are different, so it
would not be a concentric ring within the pie, but uneven small arcs within
each slice, the distance from the absolute center of the pie to each arc
varying for each slice since the percentage of the smaller number to the
larger number varies.

I couldnt find any chart types like this, so I was wondering if I need a
program like Visio or could Excel do it?

Thank you very much

Craig
 
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
How can I make a Chart data series treat blanks as "Empty" cells XLADLK Charts and Charting in Excel 12 June 9th 08 10:53 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Excel2000: Weird chart behaviour Arvi Laanemets Excel Discussion (Misc queries) 2 September 6th 05 07:48 AM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 09:21 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 04:33 PM.

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"