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" <(E-Mail Removed)> wrote in message
news:38E6B14B-FED0-4F20-8ABC-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:38E6B14B-FED0-4F20-8ABC-(E-Mail Removed)...
> > 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
> >
>
>
>