Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 11th 14, 11:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2013
Posts: 59
Default "circular" concentric charts - like a pilot's plotting/nav computer

I just reviewed this.... If you've never seen a pilot's manual plotting computer, please ignore this post. It wouldn't make sense. (This really needs a picture)

I want to make multiple concentric "pie" charts. These charts will share a common center where the smallest chart (the "inner" wheel) overlays the larger. If you've ever seen a pilot's plotting computer you know what I mean..

The inner wheel will chart 24 hours thru 360 degrees. (In this discussion, 0 degrees is directly to the right, 180, directly to the left)

The time labels in this inner (smallest) time wheel, will be inside the circle and will be normal to the circle's edge. The label at 180 degrees will be erect, the label at 0 degrees will be upside down (as viewed when 180 degrees is to the left). As you turn the wheel, numbers at the 180 "position" (the user's left) become erect.

The next larger pie chart, or "wheel" will contain process times. These labels will be on the outside of the circle, again, normal to the circle's surface. By moving the current time to inner wheel to match the current process position, the end time of the current process can be calculated. For example setting, time now - process step 4, will find an ending time across from "process complete".

I'm sure someone has done this before. Does anyone have a link?


  #2   Report Post  
Old July 17th 14, 12:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 230
Default "circular" concentric charts - like a pilot's plotting/nav computer

On 11/07/2014 23:53, wrote:
I just reviewed this.... If you've never seen a pilot's manual plotting computer, please ignore this post. It wouldn't make sense. (This really needs a picture)

I want to make multiple concentric "pie" charts. These charts will share a common center where the smallest chart (the "inner" wheel) overlays the larger. If you've ever seen a pilot's plotting computer you know what I mean.

The inner wheel will chart 24 hours thru 360 degrees. (In this discussion, 0 degrees is directly to the right, 180, directly to the left)

The time labels in this inner (smallest) time wheel, will be inside the circle and will be normal to the circle's edge. The label at 180 degrees will be erect, the label at 0 degrees will be upside down (as viewed when 180 degrees is to the left). As you turn the wheel, numbers at the 180 "position" (the user's left) become erect.

The next larger pie chart, or "wheel" will contain process times. These labels will be on the outside of the circle, again, normal to the circle's surface. By moving the current time to inner wheel to match the current process position, the end time of the current process can be calculated. For example setting, time now - process step 4, will find an ending time across from "process complete".

I'm sure someone has done this before. Does anyone have a link?


Your description of what you want is too opaque to make sense of but
can't this be roughly done already by using radar plots?

--
Regards,
Martin Brown


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
OTHER options for chart not plotting null ("") or zero values superdanz Charts and Charting in Excel 2 September 2nd 08 10:00 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Circular reference error when trying to keep a "running Tally" CrisT Excel Discussion (Misc queries) 0 June 26th 07 06:00 PM
circular files; iterating to a "correct" solution jefftlewis Excel Discussion (Misc queries) 4 December 8th 05 06:18 PM
Count and List only WorkSheets named (anything)&"-pilot" Doug[_6_] Excel Programming 1 August 11th 03 05:54 PM


All times are GMT +1. The time now is 05:21 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017