Data selection in plotting a Graph
Data selection in plotting a Graph
(OP)
Hi all..
subject looks pretty simple,but....
problem is ....i have a spreadsheet in which,for a set of data ,graph has to be plotted.
The cells in which data range is there is bound to a condition.
If once i input the data in the sheet,corresponding to this ,the data range changes & the range should be selected and get plotted.
Did i made it complicate.....
do suggest me solution on this issue.
Thank u
subject looks pretty simple,but....
problem is ....i have a spreadsheet in which,for a set of data ,graph has to be plotted.
The cells in which data range is there is bound to a condition.
If once i input the data in the sheet,corresponding to this ,the data range changes & the range should be selected and get plotted.
Did i made it complicate.....
do suggest me solution on this issue.
Thank u





RE: Data selection in plotting a Graph
prex
http://www.xcalcs.com : Online tools for structural design
http://www.megamag.it : Magnetic brakes for fun rides
http://www.levitans.com : Air bearing pads
RE: Data selection in plotting a Graph
RE: Data selection in plotting a Graph
i will try to put tat prob in a simple way.....
data table (X,Y);
X=1,2,3,4,5.......(incremental)
Y=0.2,0.4,0.6.....(force factor,formula dependenet)
X values keeps on incrementing by +1 and terminates at a particular value(conditional based).
Now the graph should be such tat it should select (X,Y)till X value terminates.Later cells should not be selected.
May be a macro sort,but i'm not able to give the shape....
RE: Data selection in plotting a Graph
> If you make the plot range arbitrarily large, Excel will dump all the blank lines. As you add data to the actual valid range Excel will add the new points to the plot.
> If you copy the last line and insert the copy just before the original last line, Excel will expand the range automatically in the plot. Then enter the new data into the current last line.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Data selection in plotting a Graph
=SERIES(,,'Dynamic Range Example.xls'!ChartData,1)
Anytime you add more data to colum A your chart will change automatically.
RE: Data selection in plotting a Graph
x: =OFFSET($A$2,0,0,COUNT($A:$A),1)
y: =OFFSET($B$2,0,0,COUNT($A:$A),1)
This assumes that your x-range starts at A2, and the y-range at B2, modify as you need.
Then, the series in your chart should have as x values range x, and y values range y, so you would type for the series formula:
=SERIES(,Sheet1!x,Sheet1!y,1)
that should do it. I think that Jon Peltier has something on this as well, google for dynamic range names and charts.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Data selection in plotting a Graph
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Data selection in plotting a Graph
Thinking about it some more, I guess I have heard of that. On this forum someone posted the Chart Formula spreadsheet by Stephen Bullen.... generates a graph from a formula types into a spreadsheet without ever using any numerical data in cells. You can adjust the x-axis range and the number of points effortlessly. Seems kind of mystical to me, but now I remember it was built on the princple of named formulas.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Data selection in plotting a Graph
the show has come to an end....Infact i was bit unfamiliar with dynamic activities in excel,in the initial stages..but anyhow now it was pretty clear...
All ur help are greatly apreaciated.
especially for jeord,whose direction to turn to Jon Peltier ......it was really awesome.
Thank u all....