Skipping Blanks in "Y" Values on Chart

B

Bill Foley

Hey Gang,

I am trying to create a spreadsheet for a years worth of data, copy the
formulas down for the remaining months, but not show "0"'s in my chart
because I don't have budget numbers for those months. Any way of doing it?
I figure I might be able to use OFFSET, but couldn't seem to get it to work.

I put in "0"'s for the remaining months so I get a flat-line until I have
real values, but I would much rather not chart those remaining months, but
also don't want to have to go in and keep changing the data range for the
chart.

BTW - Excel XP

TIA!

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Dynamic charts with named range Windows 8.1 0
Non Linear Scatter plot, need to find y value 3
Flatline on line chart 1
2003 Excel Chart with zero data 5
Copying Named Ranges in Chart Series 1
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Hide data labels with "0" values 3

Top