Why Pie Chart only one color ?

[Martin \(Martin Lee\)]

I used to create PIE CHART. As I remembered, Pie Chart has different colors
in different pie parts.

But today, I create again a pie chart but find that it only have one color.
Question: How to make it different colors in different pies.

Thanks!


Martin Lee

 

[Guest]

Open chart in design view
Right click chart
Select Chart Object
Select Edit
Right click chart again (with edit open) Make sure you click the "Chart"
not the white space
Select format Data Serise
Select Fomat Data Point
Go to Options
Select the Vary color By Choice

Hope this helps

 

[Guest]

Just has a "phone" call from ???. (by the way Hi).
and "No" the normal method won't work

CHARTNAME.Plot.SeriesCollection(index).Pen.VtColor.COLOR = INSERT-MY-STUFF
CHARTNAME.Plot.SeriesCollection(index).Pen.VtColor.COLOR = INSERT-MY-STUFF
CHARTNAME.Plot.SeriesCollection(index).Pen.VtColor.COLOR = INSERT-MY-STUFF

Unless you select the Vary Color stuff (like last answer)

It is unlikely that most people will want to "code" the colors which is why
I gave the "step - through" answer.

You owe my big time for that one greg - ??

Oh yeah and I looked at your last answer and tried it out - yes it works.

Just ha ha ha (some people a bit too serious)


-
Wayne
Manchester, England.

 

[Guest]

Since when were you from Manchester - thought you was an Essex Boy

I know you live there now but - once an Essex Boy always an Essex Boy

AND that was the most conveluted (is that how you spell it) way of changeing
a chart color I have EVER seen. What's up with a bit of code.MMMmmm

Go into a small room and have a real long talk with yourself.

 

[Guest]

But it's nice "up north".

And the chart stuff works - and it's easy.

Oh and while we are on this thing why are you sending these in from
downstairs. This is a VERY serious forum - well you'd think so by how upset
some of the posts are.



--
Wayne
Manchester, England.

The programmer formally know as
Wayne
Ilford, England.