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

Charting arrays with zero values

Posted by Carlos Blanco on March 31, 2000 6:44 AM

I need to chart a formula array which contain zero values in the last rows.

I would like to chart only the cells that contain values different than zero.

Is there anyway to do it?

Thanks

Re: Charting arrays with zero values

Posted by jimg on May 16, 2000 4:18 AM

i believe my problem is similar to carlos, my chart has months on X axis and percent on Y axis i am trying to chart from data with cells that are based on a formula. when the value is 0 or no data for the next month is available the chart's line goes to zero. this makes the chart look funny. i want all the months of the year to show but only the year to date data to show. i know if the cells are blank it looks ok but i don't want to manually update each month's cell
thanks

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.