Solved: A way to avoid charting blank cells?

[Nick_London]

Hello,

When it comes to charting a range of data is there anyway to avoid picking up blank cells in the series?

For example, in the range of A1:A500, there are some cells with no data - i.e blank cells say in A15, A40, A41, A270, A400 etc. Currently excel plots these is a line chart with gaps, is it possible instead to get the excel chart to interpolate these values automatically or would one need to interpolate the orginal raw data/delete the blank cells.

Thanks,

Nick

[Bob Phillips]

Replace the blanks with #N/A, either directly, or add a formula in B1 of

=IF(A1="",NA(),A1)

copy down and plot B1:B500

[Nick_London]

Thanks XLD.

I was hoping to avoid creating new data but it's good know there's no other way of doing it.

Thanks,

Nick