Chart Color

[Guest]

Hi,

I am creating a pie chart to resemble a clock for 1 hour. Everything is
working but I would like to define the fill color on the pie chart based on
the condition of the category name. There are only 4 options of what the
category name could be, but there can be multiple names and in a varying
order, and different for each replication. In the below example, i would
like the pie chart to show everything labeled category1=red,
category2=blue,category3=green, category4=yellow. Currently Excel applies a
different color for each line...

....And finally, I am having about 700 of these completed by different users,
so I am not looking to format after i receive each one back. Besides all the
obvious problems on having them update using a mispelled word or using more
lines than i have provided...

Thanks in advance for your help!

Data Series Example:

Prgramming Time
Category1 10.00
Category2 0.15
Category4 15.00
Category3 0.30
Category4 1.45
Category1 20.00
Category2 0.20
Category4 2.00
Category1 7.00
Category1 3.90

 

[Jon Peltier]

A couple macros at the end of this article may be just what you need:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

- Jon

 

[Guest]

Jon -

Thank you very much - this has solved my delima.

Doug