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
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