Scatter Chart data

[rfronk]

That would be great, but the boss does not want blank cells - if it's
blank then it is assumed the data is just not entered for that date.
That is why I created the whole shaded cells bit - unfortunately the
idea was not well received.... I guess I have to face the fact that I
will be spending a lot of time on this...Thanks for the suggestion!

Robin

 

[bj]

Would your boss let you use a helper sheet?
Copy all of the data to a new sheet. format the cells to make the graphs
look the way you want them to and then hide this sheet.
that way the imput data would be in the form your boss wants, but the
graphs could be made the way you want them.

 

[Jon Peltier]

bj's helper sheet would have been my next suggestion.

You could adjust the previous suggestion, so that you replace ~* with #N/A.

Could you teach the boss to recognize #N/A as a test not conducted?

Could you teach the analyst to enter #N/A directly?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______