Pie Chart showing Time Zone Comparisons - Can it be done?
 

My boss wants a pie chart showing that US Central Time (business hours) and
China Time (business hours) never overlap in a single pie chart - Can this be
done?

Pie Chart showing Time Zone Comparisons - Can it be done?
 

Hi,

Does you boss want to use the pie chart like a clock, showing a slice
for US and a slice for China business hours? If so then the clock will
have to be a 24 hour one. A quick way of doing it would be to create a
pie with 24 slices each with the data value of 1. Double click the pie
to display the format dialog. On the options tab uncheck the 'vary
colour by slice'. Now select individual slices and format the fill
colour to represent US, China or none.

Cheers
Andy


DeAnna wrote:
My boss wants a pie chart showing that US Central Time (business hours) and
China Time (business hours) never overlap in a single pie chart - Can this be
done?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Pie Chart showing Time Zone Comparisons - Can it be done?
 

To do a comparison, wouldn't a donut chart be better? And I'm thinking a
radar chart would be best of all...

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope wrote:

Hi,

Does you boss want to use the pie chart like a clock, showing a slice
for US and a slice for China business hours? If so then the clock will
have to be a 24 hour one. A quick way of doing it would be to create a
pie with 24 slices each with the data value of 1. Double click the pie
to display the format dialog. On the options tab uncheck the 'vary
colour by slice'. Now select individual slices and format the fill
colour to represent US, China or none.

Cheers
Andy


DeAnna wrote:

My boss wants a pie chart showing that US Central Time (business
hours) and China Time (business hours) never overlap in a single pie
chart - Can this be done?