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

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

http://pubs.logicalexpressions.com/P...cle.asp?ID=390

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


"Rugdoody" wrote in message
...
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 -

Thank you very much - this has solved my delima.

Doug

"Jon Peltier" wrote:

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

http://pubs.logicalexpressions.com/P...cle.asp?ID=390

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


"Rugdoody" wrote in message
...
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