Hello,

I am trying to make a simple graph with x, y coordinates. My issue is
that i want to automate the pull in of data from a table. If the cell
is blank i want excel to ignore those cells and not graph anything.
Does anyone know how to do this? I have an example below:

Number Name Xcoordinate Ycoordinate
1 A 1 1
2 B 2 5
3 C 4 10
4
5
6

I would want it to ignore cells for numbers 4, 5, and 6 and just graph
cells for numbers 1, 2, 3

Thanks so much