PDA

View Full Version : Solved: A way to avoid charting blank cells?



Nick_London
07-13-2009, 07:04 AM
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
07-13-2009, 07:20 AM
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
07-14-2009, 03:13 AM
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