Selective charting

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

hello everybody

i have a chart, a small sample of which is:

Time V1 V2 V3
0.246355 0.396997498
0.2469 0.396997498 0.823529412
0.24707 0.686868687 0.823529412
0.247385 0.686868687 0.781499203
0.247575 0.78677686 0.781499203
0.24785 0.78677686 0.823529412
0.24802 0.759170654 0.823529412
0.248305 0.759170654 0.781499203
0.2485 0.772727273 0.761460761

the cells in the V columns all contain a LOOKUP formula
that searches in a different table for V values
corresponding to the time in column A. If it doesn't find
that time in the other table, it outputs "". does anyone
know a way i can create a graph of all four columns, with
the time on the x-axis, but ignore the "empty" cells
(which are charted as value 0 at the moment)??

many thanks

iain
 
Iain said:
hello everybody

i have a chart, a small sample of which is:

Time V1 V2 V3
0.246355 0.396997498
0.2469 0.396997498 0.823529412
0.24707 0.686868687 0.823529412
0.247385 0.686868687 0.781499203
0.247575 0.78677686 0.781499203
0.24785 0.78677686 0.823529412
0.24802 0.759170654 0.823529412
0.248305 0.759170654 0.781499203
0.2485 0.772727273 0.761460761

the cells in the V columns all contain a LOOKUP formula
that searches in a different table for V values
corresponding to the time in column A. If it doesn't find
that time in the other table, it outputs "". does anyone
know a way i can create a graph of all four columns, with
the time on the x-axis, but ignore the "empty" cells
(which are charted as value 0 at the moment)??

many thanks

iain
Click to expand...

I think you should let VLOOKUP put #N/A in cells where there is no match, as
this value is ignored in graphs.
 
Back
Top