Hiya

Vlookup is getting the data into the table that feeds the line graph.

=VLOOKUP($B$2,ebookings!$A$4:H31,'Overview - by Cust'!H$99,FALSE)

Even if I put NA() in the cells that the Vlookup is using to get data, which
means NA() is appearing in the table from which the graph feeds, the options
to 'Plot Empty Cells' are still greyed out.

"David Biddulph" wrote:

Whatever formula you're using to generate your cell contents, if it's
currently setting the result to "", get it to set to NA() instead. [If you
then also want to use conditional formatting to make the N/A# cells look
empty, you can do so.]
--
David Biddulph

"Kirsty W" wrote in message
...
I have a a line graph that displays customer behaviour in a number of
categories. The data source for the graph is a table that refreshes every
time a different 'customer' is selected from a macro drop-down list above
the
table, drawing data from another table.

All the blank cells from the table are plotted as zero on the line graph,
and I can't seem to change it so that the blank cells are not plotted on
the
line graph at all. I've tried going to ToolsOptionsChart, but the 'Plot
empty cells as' options are all greyed out except for the 'Zero' option-
which I don't want!

Can anyone help......

Thanks