+ Reply to Thread
Results 1 to 4 of 4

Charts - series colours

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Charts - series colours

    Greetings,
    As part of something I'm working on, I'm trying to get two curves on a graph to have the same colour. Here's the code I'm trying to use:

    Please Login or Register  to view this content.
    However, it doesn't like that. Any suggestions?

    Thanks,
    Lady Marmalade

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

    Re: Charts - series colours

    In what way does it not like it? do you get an error message?

    perhaps you meant something like
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Re: Charts - series colours

    Quote Originally Posted by Andy Pope View Post
    In what way does it not like it? do you get an error message?

    perhaps you meant something like
    Please Login or Register  to view this content.
    I was getting an error message - I've tried a variety of things. The ones which don't come up with an error message just go white.
    Same thing occurred with yours - the second series (so SerTo in yours) became white.
    I did debug.print on the Format.Line.ForeColor.SchemeColor for the first series and it just comes up with "9" for all of them, despite them being different colours. Could this be something to do with the fact that they're set as "automatic" technically, instead of a specific colour?
    I did have some minor success by setting a random R,G & B value with each iteration and applying it to both series but it looks really aesthetically displeasing when excel's "automatic" colours aren't used...

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

    Re: Charts - series colours

    Can you post example file?

+ 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. Define colours in Bar Graphs/Charts
    By Karthik Raghuraman in forum Excel General
    Replies: 9
    Last Post: 10-13-2014, 09:36 AM
  2. [SOLVED] Adding 1 series of data in 234 charts were 3 series already exist
    By Joachimjr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2014, 01:56 AM
  3. Stock charts - how to use different colours in chart
    By AndrzejSob in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2013, 04:37 PM
  4. =SERIES and charts (adding two cells in a series formula)
    By benmmaddog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2013, 09:52 PM
  5. [SOLVED] Bubble Charts Colours go wrong
    By Darren. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-10-2006, 08:20 AM

Tags for this Thread

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