Contour plot with non-uniform X and Y distribution
Martien Janssen
Does anyone know whether there is a tool available to create contour plots
(or 3D surfaces) in Excel based on X and Y values which are not equally
distributed. I only manage to get my z-values plotted on equidistant X and Y
axis (similar to the difference between line graphs and x-y graphs in 2 D
graphs).
Thanks,
Martien
vg...@my-deja.com
Brian Murphy
application.
I have not seen any products that do this inside excel.
So you could just export or link your data to Mathcad and the make the chart
there.
I would love to see a 3rd party addin that brings this capability inside
Excel.
Old Lotus 123 had this 15 years ago.
Maybe the best bet is that Visio can do this, or will be able to do this, in
the near future.
Visio has VB built in. But I don't know if can create 3d charts of data.
Brian Murphy
--
Dr. Brian Murphy
Center for Electromechanics
The University of Texas, R7000
Austin, Texas 78712
ph: 512-232-1658
fx: 512-471-0781
b.mu...@mail.utexas.edu
Martien Janssen <reg...@wxs.nl> wrote in message
news:814m55$5330$1...@reader3.wxs.nl...
> Dear all,
>
> Does anyone know whether there is a tool available to create contour plots
> (or 3D surfaces) in Excel based on X and Y values which are not equally
> distributed. I only manage to get my z-values plotted on equidistant X and
Y
> axis (similar to the difference between line graphs and x-y graphs in 2 D
> graphs).
>
> Thanks,
>
> Martien
>
>
>
John Nurick
<b.mu...@mail.utexas.edu> wrote:
>Maybe the best bet is that Visio can do this, or will be able to do this, in
>the near future.
>Visio has VB built in. But I don't know if can create 3d charts of data.
I've played with the chart template and objects that come with Visio 5
standard. As far as I can tell they don't do 3D charting even though
some of them have a 3D appearance. It would certainly be possible to
program 3D charts in Visio/VBA, but I'm looking at specialist charting
programs first before I start re-inventing wheels!
--
John
Tushar Mehta
the quotes. While I can't vouch for any of the products, the search provided a
reasonably long list. Something I'd like to review some day. Of course, if
someone else was to do the needful and share their results...
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In <#AY3YFPN$GA.277@cppssbbsa05>, Brian Murphy <b.mu...@mail.utexas.edu> wrote
> Yes, but the ones I've seen do it "outside" of excel using another
> application.
> I have not seen any products that do this inside excel.
> So you could just export or link your data to Mathcad and the make the chart
> there.
>
> I would love to see a 3rd party addin that brings this capability inside
> Excel.
> Old Lotus 123 had this 15 years ago.
>
> Maybe the best bet is that Visio can do this, or will be able to do this, in
> the near future.
> Visio has VB built in. But I don't know if can create 3d charts of data.
>
digger
1-800-972-1021). It won't plot inside of Excel, but it will use Excel
files for data and it has a useful scripting language.
In article <814m55$5330$1...@reader3.wxs.nl>,
"Martien Janssen" <reg...@wxs.nl> wrote:
> Dear all,
>
> Does anyone know whether there is a tool available to create contour
plots
> (or 3D surfaces) in Excel based on X and Y values which are not
equally
> distributed. I only manage to get my z-values plotted on equidistant X
and Y
> axis (similar to the difference between line graphs and x-y graphs in
2 D
> graphs).
>
> Thanks,
>
> Martien
>
>
David J. Braden
resolution. or at least consensus.
Brian suggests Mathcad. Along this line, I would also suggest S-Plus,
Mathematica and Matlab. The first two can get tight links with Excel; I haven't
learned yet how to integrate a tight link between Matlab and Excel, though it
looks feasible.
Another option is DeltaGraph. It is the cheapest of the options I suggest, and
has graphing capabilities that, in some respects, go well beyond the above. Of
course, it doesn't provide the features for object-oriented stats and other fun
things that S-Plus, Mathematica and Matlab provide.
Tushar- I look forward to your review---seriously! Charting is a serious weak
spot in Excel, IMHO, and you could do a nifty survey for an INFORMS-like publication.
And Martien, could you please let us know what you settle on, and why? In the
mean time, I will explore the other suggestions. Considerations: can the
software create an EPS file? What are other criteria one might consider?
TIA,
Dave Braden
Microsoft MVP - Excel
Tushar Mehta
sent to David J. Braden <t...@fiastl.net>.]
I've used Mathematica off-and-on for the past few years. While I find it to be
useful by itself, I have been spectacularly unsuccessful in linking it with
anything. The documentation tantalizes the reader by describing the
capabilities, but lacks any concrete information about how! I can't even tell
if I need the MathLink SDK, which is a separately priced product. Given my
experience with Wolfram (the manufacturer of Mathematica), lacking substantial
confirmation about the SDK's value and an understanding about much work I would
have to put in to make it work, I have no intention of paying good money to the
company.
I would really like to learn about any public-domain or freeware or shareware
(yeah, I am willing to pay for useful stuff) software (or information) about
linking Mathematica with Excel and Word.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In <384F5B7D...@fiastl.net>, David J. Braden <t...@fiastl.net> wrote
Hotel Mercure Medellin
Martien Janssen <reg...@wxs.nl> escribió en el mensaje de noticias
814m55$5330$1...@reader3.wxs.nl...