🚀 go-pugleaf

In article <1993Jan25.190433.22024@news.columbia.edu> kra@cunixa.cc.columbia.edu (Kenneth R Aron) writes:
>Hi.
>I'm running Excel 4.0 and have a problem w.r.t. graphing.  I have
>1000 data points to plot arranged in five 200-entry columns.  Is
>there a way to make Excel go from #200 to #201, and not make the
>2nd column into another field?  I've thumbed the book and can't
>find the answer.  I >>really<< don't want to have to cut and
>paste so that all thousand pts. are in one column!
>
>Thanks,
>Ken
>Kenneth R. Aron                 NYS EMT-Defibrillation            | |  / /
>kra@cunixa.cc.columbia.edu      Columbia Area Volunteer Ambulance | |/ / 
>                                Columbia University, NYC          | |\ \
>"EMTs do it with patience"                                        | |  \ \

The easiest way is to select the first 200-entry column and create the chart.
Now select the one series in the chart.  In the formula bar, you'll see:

  =SERIES(,,Sheet1!$A$1:$A$200,1)

or something similar to that.  Change it to the following:

  =SERIES(,,(Sheet1!$A$1:$A$200,Sheet1!$B$1:$B$200,Sheet1!$C$1:$C$200,
  Sheet1!$D$1:$D$200,Sheet1!$E$1:$E$200),1)

Note the extra parentheses.  This makes the series data come from a
discontinuous selection that happens to be five adjacent columns.

Hope this helps...
  - John