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:
(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:
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.