+ Reply to Thread
Results 1 to 7 of 7

Interactive Chart Option

  1. #1
    Registered User
    Join Date
    10-05-2017
    Location
    Texas
    MS-Off Ver
    Office 2016
    Posts
    18

    Interactive Chart Option

    I produce several charts on a monthly basis similar to the one I’ve attached. Is it possible to make the chart more interactive in that if someone wants to see let’s say the Car and Boat lines (or any multiple) in the chart, all the others not selected show up gray and visible?
    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Interactive Chart Option

    This is a version that does not require any VBA. It shows/hides a line based on the checkbox, although the lines still show up in the legend. To do this I had to put your chart on a worksheet instead of a chart sheet, and create another sheet to make the charts from. This sheet has formulas that refer back to the original data, and suppress the data if the corresponding box is not checked. Each checkbox is linked to a cell in column B (hidden behind the chart) that shows TRUE or FALSE to reflect whether it's checked.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    10-05-2017
    Location
    Texas
    MS-Off Ver
    Office 2016
    Posts
    18

    Re: Interactive Chart Option

    Oooo, this is great. Is it possible that if it's unchecked the line still shows up but it shows up in gray? So that the lines not selected can be compared to the ones selected?
    I appreciate the quick help.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Interactive Chart Option

    It's possible but it's a VBA programming assignment, and I'm afraid I don't have time to tackle it.

  5. #5
    Registered User
    Join Date
    10-05-2017
    Location
    Texas
    MS-Off Ver
    Office 2016
    Posts
    18

    Re: Interactive Chart Option

    Not a problem. You have been SUPER AWESOME!!! with the help you have given me. It is perfect. I'm guessing that I can use your spreadsheet as a template and copy my chart data in there and I will be golden Thanks once again, you have no idea how wonderful this is.

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

    Re: Interactive Chart Option

    I don't know that it would require VBA to "color a series gray" when unchecked. Here's what I did:

    1) Right click on the "Raw Data and Model Chart" tab -> Move or copy sheet -> Make copy -> after a convenient tab.
    2) In the "car, boat, train.." cells (B1, E1, H1, etc.), invert the IF() function =IF(boat,"",'Raw Dat...)
    3) Add each CumOil column from the copied sheet to the chart.
    4) Format those newly added data series to have the desired grayscale color and thickness.

    With that done, when you have a box checked, the column linked to the colored data series has real data show up on the chart. The data series linked to the grayscale data series is hidden off scale. When you uncheck a box, the colored data series goes off scale, and the grayscale copy of the series shows up.

    This certainly isn't the only way to do it. The main idea is to have separate copies of the data and data series in the chart for the colored and for the grayscale versions. What I have outlined seemed like one easy way to achieve that starting from 6stringjazzer's spreadsheet.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  7. #7
    Registered User
    Join Date
    10-05-2017
    Location
    Texas
    MS-Off Ver
    Office 2016
    Posts
    18

    Re: Interactive Chart Option

    WooHoo!!! Can't wait to test this out. Thank you, thank you to you both for your time and help.

+ 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. Interactive chart
    By Yekta in forum Excel General
    Replies: 1
    Last Post: 12-10-2014, 02:10 PM
  2. Interactive Chart
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2014, 05:51 AM
  3. [SOLVED] Publish Excel Workbooks as Interactive Webpages - I dont have add interactivity option
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 02:40 AM
  4. Interactive chart
    By javierlazaromartin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2010, 07:53 AM
  5. interactive chart
    By arnab0711 in forum Excel General
    Replies: 2
    Last Post: 08-07-2010, 05:47 AM
  6. Interactive Chart
    By needsomehelpquickly in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-06-2008, 06:14 AM
  7. Interactive Chart?
    By squishyfrog in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-23-2006, 01:45 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