Prev: protect macro from a different users access
Next: slection change to make the selection go down 1 cell
From: ankur on 24 Apr 2010 11:12
HI,

Can someone give me an idea of how to plot a bounded region of data?
I have series plotted. Two of the series are basically 1/x plots
(google 'plot 1/x') which are offset along the x-axis. The other two
series are a fixed y-value along the entire x-axis, again offset.
What is created is a region bound by these 4 plots. I think I could
do this by subtracting series based on stacked area plots.

Here's the twist. Once I have the bounded region defined (or mapped
in a different color in the chart), I want to append cluster (xy) data
to the chart and analyze it based on some distance calculations to the
cluster... (blah blah for the reason).

I don't know how to append xy data to a predefined area chart.

Thanks for help.
From: Paul Robinson on 25 Apr 2010 15:41
Hi
I doubt Excel is your best option here.
Have a look at GeoGebra at www.geogebra.org - it's free and you can
run it from the website but save your files locally. It has a really
fast learning curve. It has a spreadsheet functionality too. Check the
GeoGebra Help, Wiki and Forum to see how things are done.
regards
Paul

On Apr 24, 4:12 pm, ankur <an01digitalservi...(a)gmail.com> wrote:
> HI,
>
> Can someone give me an idea of how to plot a bounded region of data?
> I have series plotted.  Two of the series are basically 1/x plots
> (google 'plot 1/x') which are offset along the x-axis.  The other two
> series are a fixed y-value along the entire x-axis, again offset.
> What is created is a region bound by these 4 plots.  I think I could
> do this by subtracting series based on stacked area plots.
>
> Here's the twist.  Once I have the bounded region defined (or mapped
> in a different color in the chart), I want to append cluster (xy) data
> to the chart and analyze it based on some distance calculations to the
> cluster... (blah blah for the reason).
>
> I don't know how to append xy data to a predefined area chart.
>
> Thanks for help.

 | 
Pages: 1
Prev: protect macro from a different users access
Next: slection change to make the selection go down 1 cell