relative charting

  • Thread starter Thread starter jørgen kanters
  • Start date Start date
J

jørgen kanters

BlankI have a plot with the statement below

=SERIES(;template!$A$1:$A$32000;template!$B$1:$B$32000;1)

instead of specific giving the range

I want to have a two cells where I can define start and stop of the graph,
and then change the graph dynamically

for example giving

D1 is start and
D2 is end

The above =SERIES example correspond to D1=1 and D2=32000

and when I change D1 and/or D2 the graph changes correspondingly.

Is that possible and how.

If possible please mail me the answer

(e-mail address removed)

Jørgen
 
Back
Top