Ignoring Blank Rows When plotting a chart
Posted by Karen G on September 30, 2001 2:21 AM
I have an Excel spreadsheet that will have a variable number of rows taking data - I want to be able to create a chart that can take data from rows 1-260, but if there is only data in rows 1-150 will only plot those. At the moment if any rows are blank it just doesnt plot them, but still scales the axis as if there was 20 entries so i end up with a blank section at the end! Is there any way to avoid this?