Hey all,

I am looking to make a heat map (bubble graph) which allows you to filter what plots on the graph based on a few descriptive criteria.

In the bubble graph, there are three "scoring" variables (x-axis, y-axis and bubble size), but each item in my graph also has two associated descriptive data points. The first data point can be three possible options (x,y,z), and the second data point is a yes, no question. I am looking to be able to filter what shows in the heat map based on the two descriptive criteria.

For example: Only show things in the bubble chart where descriptive criteria #1 = X and descriptive criteria #2 = Yes

I have attached a sample worksheet which might be more helpful to understand what I am looking for.

Thanks

Excel_Help1.xlsx