+ Reply to Thread
Results 1 to 2 of 2

color conditions on xy scatter chart and show/hide series and legend name for true/false

  1. #1
    Registered User
    Join Date
    03-24-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    74

    color conditions on xy scatter chart and show/hide series and legend name for true/false

    Hi there everyone

    I got a few questions here that I'm very much hoping you can help me with ...

    1st: I'm looking for a way to change the color of this month line and maybe even make the line bold ...

    2nd: if there's no data in the series I would like to have it not showing both the line as well as the Legend name (or if I've chosen not to show that line with a checkbox)

    finally I got my data set up without codes so that I can get gaps in the line to better give a visual picture of the data.

    OH and then I'm hoping you can help me get some better informations on the points when you hover over them ... I need to get one more number showing (Insulin) next to the last number

    (Data is in sheet2)
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: color conditions on xy scatter chart and show/hide series and legend name for true/fal

    You can accomplish the last part by putting code on the sheet that displays the chart - in the example attached when you click on a point, it gives you the date that the measurement was taken on.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-26-2015, 12:00 PM
  2. How to create show or hide the data series in Scatter Chart
    By anandltvs in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-26-2015, 10:50 AM
  3. [SOLVED] Charts - Show/Hide series (Scatter Plot)
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2014, 02:47 PM
  4. Hide Show rows based on cell value true or false using VBA
    By gopal904 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2013, 07:31 AM
  5. Set chart series color to match series legend entries font color
    By Equipoise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 07:33 AM
  6. [SOLVED] Exclude one data series from scatter chart legend (but not from the chart)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 05:24 PM
  7. How to hide a dummy series in a chart legend?
    By holg3r in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-14-2005, 04:04 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