Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Why Pie Chart only one color ?

Discussion in 'Information Technology' started by Martin \(Martin Lee\), Jul 28, 2006.

Tags:
  1. Martin \(Martin Lee\)

    Martin \(Martin Lee\)
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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



    --
    Wayne
    Manchester, England.



    "Martin (Martin Lee)" wrote:

    > 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
    >
    >
    >
     
  4. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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.



    "Wayne-I-M" wrote:

    > 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
    >
    >
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Martin (Martin Lee)" wrote:
    >
    > > 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
    > >
    > >
    > >
     
  5. Stevo

    Stevo
    Expand Collapse
    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.
     
  6. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    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.
     

Share This Page