Friday Challenge On Thursday – Only Show Selected Data Points in an Excel Chart

Hi Excel Fans,

Today I am posting the Friday Challenge a day early to give you time to try it out.

Here the user story on what we are trying to do:

‘As an Excel user I want to leave all my data intact (i.e. not delete or hide any rows) and I want to conditionally show the data points in an Excel column chart by typing in “Yes” next to the data.’

Here is what I mean with pictures:





GIF  How-to Only Show Selected Data Points in an Excel Chart

(See as I type in a Yes in column C, then the data point is added to the Excel Chart and as I delete the Yes the column is removed from the graph.)

Here is the data set (Copy and paste it from this table to cell A1 in your test spreadsheet:
Excel 2012

ABC
12011Display
2a330.33Yes
3b329.35
4c359.85
5d376.94Yes
6e446.86Yes
7f457.7
8g509.38
9h549.9Yes
10i566.84
11j585.2
12k658.24Yes
13l720.2

 



There are probably several ways to complete this task, so lets see what you got.  If you want to contact me to send in how you did it, leave me a comment below (it asks for your email) and I will contact you for the file.

Good luck!

Steve=True





8 COMMENTS

  1. Hello! I am new to this forum & like your Blog very much. I have a solution for the challenge. I just have another table based on ‘Yes’ & Row number to extract the value from the main table. Finally I have used offset & named ranges to define its Series & category name. I can send my solution if you provide me your email address. Thanks.

LEAVE A REPLY

Please enter your comment!
Please enter your name here