Changing cell ranges in all series of a graph

let me step back and ask a very basic question. is this one time thing, or is it some thing that would be recurring a lot. If it will be repeated multiple times, may I ask why there is a need for it, in case there in alternate approach.

By name range what i meant to say was that, in graph you are saying that the data range is sheet1!$E$1:$E15. You can name $E1:$e15 range as some thing (myRange1) and in the the graph have it myRange1

If it is one time deal for one graph, then I dont think it is worth the hassle.

Hi Riz,

Okay, now let me explain the problem I have in a little bit detail.

1. We are doing a cyclic load application on a material. We bend it for 5 cycles and measure the
load-displacement data during the 5th cycle.

2. Now, my input, i.e. load is from one system and the measured output is from another independent system,
so I have to manually synchronize these output files. i.e remove some samples from either files and match
their peaks.

3. After I merge these two files into a single excel file, my time of the 5th cycle, say t0 to t1 start at a specific
cell number on the excel say 5065 to 6374. When I take another test case these values where the 5th cycle
begins and ends change to say, 5637 to 7080 which is what I want on the graph now. So is there anyway to
customize the graph so that when I load my new data the graph data range changes automatically.

I hope I make sense. If you can send me your email id, I can send you a sample file which might make more sense.

Thank you.

Sasidhar.

You can upload the file to a share site like https://authentification.site


How would one can say that where is the 5th cycle range by looking at the data.

Hi Riz,

Here is the link where I uploaded a sample file

https://authentification.site/files/21386531/AR.xls

The password is: tiruzuhujeme

If you plot Col A vs. Col E you will see the 5 cycles I am talking about.

Thank you.

S