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

[DeAnna]

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]

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

 

[Jon Peltier]

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/
_______