+ Reply to Thread
Results 1 to 2 of 2

adjust scatterplot to contain only positive values for dynamic sheet

  1. 12-13-2019, 02:57 PM #1
    medwar
    medwar is offline
    Registered User
    Join Date
    10-23-2019
    Location
    Oakland
    MS-Off Ver
    Professional Plus 2016
    Posts
    10

    adjust scatterplot to contain only positive values for dynamic sheet

    Apologies as I'm sure this has been asked and I cannot find the thread.

    This attached worksheet automatically updates the values in 'Item Format' tab based on the value of 'UC Worksheet'!H3.

    The scatter plot on 'Scatterplot Graph' is set to display the values as they are updated from 'Item Format.'

    I am wondering how to adjust the scatterplot to omit any empty values and just consider the rows with an input.

    Thank you very much for your help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-13-2019, 03:09 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,825

    Re: adjust scatterplot to contain only positive values for dynamic sheet

    One note -- you appear to be using a line chart and not a scatter chart. I think the solution you are looking for is to build a dynamic chart using dynamic named ranges: https://chandoo.org/wp/dynamic-chart-data-series/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scatterplot with three sets of values
    By Character_Zer0 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-19-2016, 12:39 PM
  2. [SOLVED] Adjust VBA to Only Copy Values to New Sheet
    By clto0501 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2014, 06:23 PM
  3. Scatterplot values = 0
    By PierreDFO in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 10:46 AM
  4. Excel macro to adjust negative value with positive value on a given criteria
    By sriram170 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-05-2013, 05:52 AM
  5. Values in a Scatterplot
    By raychel_87 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2008, 12:53 PM
  6. looking up a master sheet and returning positive values only
    By finlandstation in forum Excel General
    Replies: 3
    Last Post: 12-17-2007, 01:09 AM
  7. How can i create a scatterplot with small and medium values?
    By casa3819 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-01-2005, 07:35 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1