+ Reply to Thread
Results 1 to 9 of 9

error with chart fill color

  1. #1
    Registered User
    Join Date
    01-12-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    28

    error with chart fill color

    I am trying to get the Chart to appear as the color below but gives error.What is missing?


    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: error with chart fill color

    I'm not quite sure what you want but the following will color the entire active plot area:
    Please Login or Register  to view this content.
    Lewis

  3. #3
    Registered User
    Join Date
    01-12-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: error with chart fill color

    Thanks

    I have 4 Columns in the chart and I want to color them individually..the code below worked but I wanted to change the color setting for RGB to make easier to change

    Please Login or Register  to view this content.
    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: error with chart fill color

    Heres one way..

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-12-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: error with chart fill color

    apo...thanks as it works good

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,488

    Re: error with chart fill color

    your example code worked for me.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  7. #7
    Registered User
    Join Date
    01-12-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: error with chart fill color

    Andy,
    Yep it worked but i wanted to use the RGB colors such as (128, 0 , 128)...just easier to change then say a number like this - 15130800

    How would you change this code to accept say (128 , 0 , 128)
    Please Login or Register  to view this content.
    Cheers

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,488

    Re: error with chart fill color

    Okay, this works as well. Red. greeb, blue and grey columns.

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    01-12-2014
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: error with chart fill color

    Andy
    Thanks
    I left out the second RGB which is why it did not work
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Possible to conditional format fill color of pivot chart bars?
    By DaveF in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-31-2013, 09:12 AM
  2. Help on making a chart with cells no value but fill color only -
    By nolivy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-23-2012, 07:28 AM
  3. Fill color between two XY line in chart in excel 2007
    By tomopaljk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-31-2011, 06:26 PM
  4. Color Fill Regions on Chart Based On Value?
    By zackpasi in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 06-18-2009, 10:42 AM
  5. Can I change the colors in the fill color chart?
    By Genesis Pat in forum Excel General
    Replies: 2
    Last Post: 03-28-2006, 02:55 PM

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