Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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?

Re: Ignoring Blank Rows When plotting a chart

Posted by Robin on October 01, 2001 3:15 AM

You could try creating your chart as normal using a few rows of data and then setting this as the default chart through Chart, Chart Type, User Defined, Add..., Set as Default...

From this point you can select however many rows contain data and press F11 on the keyboard to produce this default chart based on the cell / rows selected.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.