Plot every other cell

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!

Adam wrote:
> 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

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

--
Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP -- Excel

In article <023f01c3418d$59f9c080$a301280a@phx.gbl>,
drost@ci.wilsonville.or.us says...
> 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!
>