Changing cell ranges in all series of a graph

Solved/Closed
Sasi - Mar 8, 2010 at 05:08 AM
 Kenneth Just - Mar 28, 2010 at 01:19 PM
Hello,

I have a graph with 5 series on it.

='Entire series of data'!$E$17,'Entire series of data'!$E$5066:$E$6375,'Entire series of data'!$I$17,'Entire series of data'!$I$5066:$I$6375,'Entire series of data'!$P$17,'Entire series of data'!$P$5066:$P$6375,'Entire series of data'!$W$17,'Entire series of data'!$W$5066:$W$6375,'Entire series of data'!$AD$17,'Entire series of data'!$AD$5066:$AD$6375,'Entire series of data'!$AK$17,'Entire series of data'!$AK$5066:$AK$6375

I want to change my cell range from 5066:6375 to someother value, say 1:1000, can I do this without manually selecting each series and then clicking edit and then changing them.

Thank you.

Sasi

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 8, 2010 at 08:39 AM
I have never done it, but just wondering if a named ranged would work. just a thought
1
Hi riz,

Thanks for your reply. I am not that a master in excel. Can you kindly elaborate on your answer or just give an example which I can take as a lead.

Thank you.

Sasi
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769 > Sasi
Mar 9, 2010 at 08:56 AM
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.
0
Sasi > rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022

Mar 11, 2010 at 07:53 AM
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.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769 > Sasi
Mar 11, 2010 at 09:37 AM
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.
0
Sasi > rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022

Mar 12, 2010 at 07:49 AM
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
0