Plot every other cell

[Adam]

I have a spreadsheet that contains half hour information.
In a column, I combine numbers for two half hour periods
to calculate an hourly number. I do this in every other
cell. However, when I try to plot these hourly numbers,
my chart shows no line since every other cell is blank.

Is there a way to have Excel create a graph using evey
other cell?

Thanks!

 

[dvt]

I have a spreadsheet that contains half hour information.
In a column, I combine numbers for two half hour periods
to calculate an hourly number. I do this in every other
cell. However, when I try to plot these hourly numbers,
my chart shows no line since every other cell is blank.

Is there a way to have Excel create a graph using evey
other cell?

Thanks!

Try filling the empty cells with =NA().

Dave
dvt at psu dot edu

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Adam.
Please use the newsgroup for further discussion.]

You could use a named formula. Create one with Insert | Name >
Define...

EveryOtherCell
=N(OFFSET(Sheet2!$B$1,(ROW(OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$B:
$B),1))-1)*2,0,1,1))

This assumes you have data in every other row starting with B1. Now,
create the chart with this named formula. For more on how to use named
formulas in a chart see the Dynamic Charts page of my web site.