Results 1 to 3 of 3

Conditional Charting

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-30-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2013
    Posts
    251

    Conditional Charting

    I have three rows of data with which I would like create a scatterplot with 2 out of the 3 depending on a condition. Regardless of the condition, both charts will use the same Y axis (in this case, row 2). But depending on my decision cell (N4), I want to use either Row 3 or row 4 as my X axis. This seems like an obvious use of an IF statement but that doesn't seem to interact well with the SERIES function. Does anybody have any suggestions? Thanks.
    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. Markers of graph (conditional charting)
    By Beginner Level in forum Excel General
    Replies: 1
    Last Post: 03-03-2012, 06:01 PM
  2. Conditional charting
    By omer123456 in forum Excel General
    Replies: 2
    Last Post: 12-20-2011, 09:26 PM
  3. Excel 2007 : Charting
    By plmichel in forum Excel General
    Replies: 1
    Last Post: 11-04-2011, 01:39 PM
  4. Excel 2007 : Charting
    By plmichel in forum Excel General
    Replies: 1
    Last Post: 11-03-2011, 03:54 PM
  5. Pass/Fail array using conditional formatting and charting
    By phstol in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2009, 10:14 AM
  6. Dynamic Conditional charting
    By Qlychap in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-30-2007, 12:31 AM
  7. [SOLVED] Custom charting - Stacked charting with a line
    By Randy Lefferts in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-03-2005, 12:06 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