+ Reply to Thread
Results 1 to 5 of 5

Can't automate X axis range to cell value or have two fill colours

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,391

    Can't automate X axis range to cell value or have two fill colours

    Apologies if this has been covered already, but couldn't find anything that worked!

    Cols F and G on the DATA sheet calculate the months and values automatically, based on value and date set in the GRAPH sheet.

    Following Worksheet_Change Code changes the Lowest Value correctly when the value in D36 changes (Highest Value is always D241) for the Y axis, but can't get it to use the First and Last months in Col F of the DATA sheet for the X Axis.

    Please Login or Register  to view this content.
    Second challenge is need to change the "fill" colour in the graph where dates are after the current month. So on the attachment as sent, the graph fill for dates in F2 - F70 should be blue, but from F71 - F210 it should be orange.

    No clue how to arrange that.

    All solutions, suggestions and alternatives to either issue welcome as ever.

    Ochimus
    Attached Files Attached Files
    Last edited by Ochimus; 10-16-2019 at 10:14 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Can't automate X axis range to cell value or have two fill colours

    Hi, I have not looked at your file but as far as I know a data series can only have one color
    You should probably need to take another approach like a gantt chart and maybe even use the conditional format options the newer versions (as yours is) currently offers but are not compatible with older versions.
    I'll download your file and see if I can help, but don't think the two-color part will be possible in one data series
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Can't automate X axis range to cell value or have two fill colours

    BTW the file you attached is linked to the file on your system so no go. C:\Users\Robert\Downloads is NOT accessible for us.
    When you copy things like this make sure there are no EXTERNAL LINKS to files not accessible to others.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Can't automate X axis range to cell value or have two fill colours

    A litlle cceative modification and I got you chart.
    Probably you will have to create two series on-the-fly, one for the older range and update every day (just an idea, don't know it it's possible but think about this)

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Can't automate X axis range to cell value or have two fill colours

    I've attached the ide, I added a formula column that places a 0 for prior to current month dates and a 1 for current month up
    Maybe you can split the series into these two ranges ?
    This is just to illustrate my idea, not the solution you want
    Attached Files Attached Files

+ 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] Excel Cell Fill Colours
    By mikekelly1978 in forum Excel General
    Replies: 5
    Last Post: 05-30-2019, 08:15 AM
  2. How to automate: select range and drag down to auto fill ?
    By pisdukas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2016, 02:56 AM
  3. How to automate select range and drag down to auto fill ?
    By pisdukas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2016, 02:39 AM
  4. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  5. How do I set up conditional cell fill colours in Excel?
    By Naomi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] How do I set up conditional cell fill colours in Excel?
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  7. How do I set up conditional cell fill colours in Excel?
    By Naomi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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