Results 1 to 15 of 15

Extraneous Dates Showing in Dynamic Scatter Chart

Threaded View

mdjones2 Extraneous Dates Showing in... 01-12-2024, 12:18 AM
Marius44 Re: Extraneous Dates Showing... 01-12-2024, 04:08 AM
mdjones2 Re: Extraneous Dates Showing... 01-18-2024, 10:37 PM
mdjones2 Re: Extraneous Dates Showing... 02-01-2024, 11:21 PM
MrShorty Re: Extraneous Dates Showing... 01-19-2024, 12:27 AM
mdjones2 Re: Extraneous Dates Showing... 01-22-2024, 10:41 PM
MrShorty Re: Extraneous Dates Showing... 01-22-2024, 11:15 PM
mdjones2 Re: Extraneous Dates Showing... 01-24-2024, 02:58 AM
AliGW Re: Extraneous Dates Showing... 01-24-2024, 02:59 AM
mdjones2 Re: Extraneous Dates Showing... 01-24-2024, 03:10 AM
AliGW Re: Extraneous Dates Showing... 01-24-2024, 03:29 AM
MrShorty Re: Extraneous Dates Showing... 01-24-2024, 12:22 PM
mdjones2 Re: Extraneous Dates Showing... 01-30-2024, 01:41 AM
MrShorty Re: Extraneous Dates Showing... 01-30-2024, 02:24 PM
MrShorty Re: Extraneous Dates Showing... 02-02-2024, 12:23 PM
  1. #1
    Registered User
    Join Date
    03-08-2020
    Location
    West Coast USA
    MS-Off Ver
    O365
    Posts
    7

    Extraneous Dates Showing in Dynamic Scatter Chart

    Dynamic range based on entry in D21 that limits the number of days (Rows) to display.
    Chart populates extra dates on front and back and weekend/holiday dates which are not part of the values presented in A3:A17.
    I've tried UDF, Named Ranges, Direct and indirect Cell References with no success. Also tried to change the Type to Text but not available in Excel 2016 that I can find.
    Axis Boundaries Min/Max only take values or auto and no formula, cell reference or named reference are accepted.
    In the attached I'm commented out the UDF lines and the two cell references in F18 and F19. None of them worked in the desired manner and are included to demonstrate how far I've taken this.
    Sheet is presently loaded with just one set of values from column B, and the reference date range in A but still populates extraneous/unlisted date values.
    Goal is to reduce the clutter and just present the contents (dates and percentages) from the cells in the sheet each time D21 is changed.
    Attached Files Attached Files
    Last edited by mdjones2; 01-12-2024 at 12:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Scatter Plot Chart Picture
    By RuKeBo in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-17-2020, 05:24 PM
  2. XY Scatter with dynamic dates
    By vhawk12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-29-2018, 05:03 PM
  3. Replies: 2
    Last Post: 02-13-2014, 06:18 AM
  4. scatter chart showing data outside of range
    By hansaaa in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-30-2013, 02:57 PM
  5. Dynamic Range for Chart scatter plot
    By dpk1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-30-2013, 03:29 AM
  6. Scatter chart/ correlation between 2 dates
    By ruangeld in forum Excel General
    Replies: 1
    Last Post: 07-07-2012, 10:02 AM
  7. Values from Hidden Column not showing in scatter chart
    By dshilan in forum Excel General
    Replies: 2
    Last Post: 06-17-2010, 10:46 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