Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
NEED HELP WITH PULLING IN ONLY NECESSARY DATA FROM A TABLE
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
NEED HELP WITH PULLING IN ONLY NECESSARY DATA FROM A TABLE
Are the cells truly blank, or do they contain formulas that return "". "" is
a piece of text, which Excel treats as a zero: change "" in the formula to NA(), which puts an ugly #N/A error in the cell but isn't plotted in a line or XY chart. If they really are blanks, then go to Tools menu Options Chart tab, and choose Not Plotted for how Excel should treat blank cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "lenubian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table pulling wrong value | Excel Discussion (Misc queries) | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
Linking two spreadsheet, pulling data from one cell to another, data is being truncated | Excel Worksheet Functions | |||
pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
Pulling from a table to make a timeline | Excel Worksheet Functions |