Conditionally show points on a scatter chart

[robfoster2000]

Hi All.

I have a table of data which I want to represent in a scatter chart.

However, I would like to be able to set a flag against each row in the table to specify whether or not the point should actually appear on the chart or not. This way I can decide which are the pertinent data points to show. I am building a risk visual based on impact and likelihood by reading a list of risks. However, I want the risk visual to only show open risks and those which the user decides are important enough to show.

Is this possible using normal chart settings or would I need to dabble in VBA to achieve it?

Thanks!
Rob.

 

[Jeffrey Mahoney]

Seems to me that you would create a new column that is a flag for each row. The formulas in the rows would have to incorporate looking at the flag value and setting the result to NUL or "". The flag values could be zeros and ones or some other characters.

Jeff