Plot every other cell

  • Thread starter Thread starter Adam
  • Start date Start date
A

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!
 
Adam said:
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!
Click to expand...

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.
 
Back
Top