+ Reply to Thread
Results 1 to 7 of 7

Matching 'Chart Series title' to equation driven cells to set the series line colour

  1. #1
    Registered User
    Join Date
    11-12-2018
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2016 (Office 365 ProPlus)
    Posts
    58

    Lightbulb Matching 'Chart Series title' to equation driven cells to set the series line colour

    I am struggling to get the below code to find a match between the Chart Series name & a selected Range cell text, but only when both are driven by equations. If no equations are used (and text only is used in the colour cells) it works fine. Any ideas why this may be the case?

    Please Login or Register  to view this content.
    Also attaching a simplified worksheet to illustrate the problem. If you click the 'Refresh' button above the chart on the second worksheet then nothing happens. But replace the equations in the Colour table with plain text (A, B, C etc...) then hit refresh and all will work just fine!! Thanks for any help!
    Attached Files Attached Files
    Last edited by mattydboom1; 02-14-2020 at 03:25 PM.

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

    Re: Matching 'Chart Series title' to equation driven cells to set the series line colour

    include the LookIn parameter

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

  3. #3
    Registered User
    Join Date
    11-12-2018
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2016 (Office 365 ProPlus)
    Posts
    58

    Re: Matching 'Chart Series title' to equation driven cells to set the series line colour

    Yes Andy! Thank you!!!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Matching 'Chart Series title' to equation driven cells to set the series line colour

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    11-12-2018
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2016 (Office 365 ProPlus)
    Posts
    58

    Re: Matching 'Chart Series title' to equation driven cells to set the series line colour

    Andy I could also do with modifying the code so that instead of looking at the same cell (the one probed for the text match) for the associated fill colour, it would instead look at the neighbouring cell.

    I.e coloured cells all in table column 1, and the text to match against in table column 2. Presumably I will need to use an Offset somewhere?? But have tried and failed so far.... Is there a simple fix do you know?
    Last edited by mattydboom1; 02-15-2020 at 09:33 AM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Matching 'Chart Series title' to equation driven cells to set the series line colour

    If you need more help with this, you should remove the SOLVED tag.

  7. #7
    Registered User
    Join Date
    11-12-2018
    Location
    Cornwall, England
    MS-Off Ver
    Excel 2016 (Office 365 ProPlus)
    Posts
    58
    Quote Originally Posted by AliGW View Post
    If you need more help with this, you should remove the SOLVED tag.
    I have switched back 'Answered' as have submitted the second query as a new thread. Thanks
    Last edited by mattydboom1; 02-16-2020 at 06:21 AM.

+ 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] VBA for recolouring all series in a chart the same colour
    By HanJam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2019, 07:15 AM
  2. [SOLVED] VBA - Search Chart for Data Series Title and format.
    By rtcwlomax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2017, 09:16 AM
  3. Change colour of chart series with VBA
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-17-2017, 10:06 PM
  4. Chart Series Automatic Colour
    By AndersonM in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-01-2016, 06:37 AM
  5. [SOLVED] Change series line colour to match marker colours
    By sweep in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-15-2014, 03:04 AM
  6. [SOLVED] Align Line Chart's data series Data labels on top of Bar chart data series
    By rgunlimited in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2014, 10:38 AM
  7. Change colour of chart series
    By downunderthunder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2010, 09:20 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