Changing Chart Data Series

Discussion in 'Microsoft Access VBA Modules' started by Guest, Jan 3, 2006.

  1. Guest

    Guest Guest

    Is is possible to change a chart's series color with vba code?
     
    Guest, Jan 3, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    It is possible to change chart's data series color with vba code. I used the
    following code:


    mychart.SeriesCollection(1).Interior.ColorIndex = 12


    I did a little playing around and I finally got it.

    Hope this can be helpful to someone else.

    "shun" wrote:

    > Is is possible to change a chart's series color with vba code?
     
    Guest, Jan 10, 2006
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike Collard

    How to refer to a chart series name

    Mike Collard, Mar 22, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    183
    Mike Collard
    Mar 22, 2004
  2. Mike Collard

    Formatting chart with variable series

    Mike Collard, Sep 1, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    297
    Mike Collard
    Sep 1, 2004
  3. Guest

    Code to format data series?

    Guest, Nov 24, 2004, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    162
    Guest
    Nov 24, 2004
  4. Guest

    Changing pivot table view into chart view using vba

    Guest, Aug 20, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    0
    Views:
    302
    Guest
    Aug 20, 2005
  5. Guest

    Syntax for changing chart in report

    Guest, Nov 15, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    1
    Views:
    162
    Guest
    Nov 15, 2005
Loading...

Share This Page