Results 1 to 2 of 2

adjust scatterplot to contain only positive values for dynamic sheet

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1