+ Reply to Thread
Results 1 to 5 of 5

Automatic Axis Tidying - Interactive Chart

  1. #1
    Registered User
    Join Date
    01-15-2020
    Location
    Hull, England
    MS-Off Ver
    2013
    Posts
    3

    Automatic Axis Tidying - Interactive Chart

    Hi, Hopefully I've successfully attached an example of how far I've got.

    This is formed on an example I found on the 'Net and I've added to in order to make it interactive on both the X and Y axis. I've created a data table, interactive data table with the use of check boxes and an associated basic line chart. The data goes through Jan to June. Currently if I untick Jan then #N/A shows up in the X axis of the chart. What I would like is if I untick Jan, is excludes Jan and the X axis reforms starting with Feb. I thought it might have something to do with the axis type in Axis options, but I've played around in there to no avail.

    This is just an example, but as the spreadsheet is developed, I expect there to be many months of data added, and it is likely that only the latest months will need to be plotted on the chart. I don't want a big gap on the left hand side of the chart as these earlier months are unticked.

    Many thanks in anticipation.

    Ian
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,536

    Re: Automatic Axis Tidying - Interactive Chart

    I've added some dynamic ranges for months and areas.
    And change NA() into 0 to help deal with ranges as above.

    check attached file.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    01-15-2020
    Location
    Hull, England
    MS-Off Ver
    2013
    Posts
    3

    Re: Automatic Axis Tidying - Interactive Chart

    Hi, thanks for your help. Really appreciated. I've never considered dynamic ranges and I've always struggled with OFFSET.

    I get this error though when I untick an area and a month.

    Cheers,

    Ian

    Attachment 657939

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    1,536

    Re: Automatic Axis Tidying - Interactive Chart

    Try to paste picture once more.
    Check attached file, accidentially I've created today something for my friend to display range of months.
    Maybe it gives you a clue.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-15-2020
    Location
    Hull, England
    MS-Off Ver
    2013
    Posts
    3

    Re: Automatic Axis Tidying - Interactive Chart

    Hi KOKOSEK, Hopefully I've been able to add the image this time - the error message says "We found a problem with one or more formula references in this worksheet. Check the cell references, range names, defined names and links to other workbooks in your formulas are all correct." I get this when I untick one of the areas on the left hand side. I've looked at the Name Manager references, but I can'tr seem to work them out. Many thanks for all your time and effort,

    Ian
    Attached Images Attached Images

+ 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