About Us

Martin Brown

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 05:18 PM
Count and List only WorkSheets named (anything)&"-pilot"	Doug[_6_]	Excel Programming	1	August 11th 03 05:54 PM

Menu

About Us