+ Reply to Thread
Results 1 to 4 of 4

Stacked Area Chart Series Colour Change

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    16

    Unhappy Stacked Area Chart Series Colour Change

    hi

    I have a stacked area chart located on its own individual worksheet. I would like to use VBA to apply colours to individual series based on the name of that series. I have applied the following code which I found on the following help forum, changing it slightly to fit my needs: http://www.ozgrid.com/forum/showthread.php?t=91381

    Please Login or Register  to view this content.

    Can some one please identify the problem with this code as it doesnt cause any change in the chart

    cheers

    DUT
    Last edited by downunderthunder; 01-06-2010 at 09:19 PM.

  2. #2
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Re: Stacked Area Chart Series Colour Change

    are you able to post an example workbook?
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    01-04-2010
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Stacked Area Chart Series Colour Change

    unfortunatly no the data is somewhat confidential

  4. #4
    Registered User
    Join Date
    01-04-2010
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Stacked Area Chart Series Colour Change

    I figured it out myself

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1