Charting points that are not consecutive in a data table

  • Thread starter Thread starter eltrutori3
  • Start date Start date
E

eltrutori3

Any help or suggestions are appreciated. The problem is this:

I have a set of data that looks like this:

Date 10/15 10/17 10/20 10/21 10/22
Vault 80% #DIV/0! #DIV/0! 80% #DIV/0!
Bars 20% #DIV/0! 60% #DIV/0! 90%
Beam 15% 23% 20% 12% 50%
Floor #DIV/0! #DIV/0! 100% #DIV/0! 93%

. . . and it goes on until the end of November. The invalid number
exist because the individual did not work on that particular apparatu
that day. There is no particular pattern to the days which individual
perform on one apparatus and not another.

I need to chart their percentages all on one chart, but do not want t
chart the invalid entries.

I've tried multiple select by using the "Ctrl" key, but all that doe
is IGNORE the entry and shift every one after that one over (so that i
doesn't coincide with its date anymore). So, my question is, does
placeholder exist in excel which will not show up as a plotted point o
the graph? Or perhaps, is there another way to get it to grap
non-consecutive data?

Thank you!

edit: graph of choice is an xy scatter or a line graph. My only othe
option is to do a scatter with just the points and to connect the dot
myself, ignoring those that result from invalid entries
 
An xy scatter and use the Control key to select both the x and y
values.

I feel stupid, now, because that seemed easy.

::crosses fingers::

hopefully it works!
 
An alternative would be to replace error conditions with NA(). Now, X
charts will automatically ignore the bad values.
 
Back
Top