+ Reply to Thread
Results 1 to 1 of 1

conditional text/symbol for line/scatter charts (bonus VLOOKUP() example)

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    conditional text/symbol for line/scatter charts (bonus VLOOKUP() example)

    Two things I want to do with this tip.

    I got the idea here a couple of months ago to use data labels (centered on the point) to "conditionally format" chart symbols. By linking the data label text to the spreadsheet cells (I use Rob Bovey's XY chart labeler add-in from appspro.com I understand that this functionality is native to Excel starting in 2013). Note that this will only allow you to format characters for the symbols based on your conditions. If you want to choose different colors or other formats, you will want to use a technique like this one: http://peltiertech.com/conditional-f...-excel-charts/

    In this case, I am using a VLOOKUP() function to select the desired symbol from the lookup table. Note in particular how I am using TRUE as the 4th argument in the lookup function, so that Excel does not just look for the exact match, but will match anything within the ranges defined by the lookup values (left column) in the lookup table. It seems that almost all of the lookup examples on the internet are set up for exact match FALSE as the 4th argument -- which works fine for unsorted data or when you otherwise want to find exact matches. I see a lot of questions that can make use of this "approximate match" "binary search" option.
    Attached Files Attached Files
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line/Scatter Charts only work with certain columns of Data
    By KellyD in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-21-2016, 06:27 PM
  2. [SOLVED] Multi-line text box inserts a carriage return symbol in cell, can I stop/remove it?
    By loveridge01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-29-2016, 10:43 AM
  3. IF(ISERROR(VLOOKUP with text/symbol search
    By DarthBrute in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2014, 10:53 AM
  4. text line break symbol to use in a formula
    By pwermuth in forum Excel General
    Replies: 2
    Last Post: 05-17-2009, 07:46 PM
  5. text boxes that label axes in line/scatter graphs
    By Peg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-09-2006, 04:55 AM
  6. [SOLVED] Scatter and line charts
    By Chi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2005, 03:20 PM
  7. Control Size of Scatter Chart Symbol
    By Bill Sturdevant in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2005, 07:05 PM

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