Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Scientific charts: what is the best add-in or package for getting sane ones?


I need a normal scientific chart. You know, the ones with axes on the
right, left, top, and bottom sides. I think I did this once before and
it took an hour, since I had to trick excel into thinking i had about
four different sets of data, most of which were fake. It was insane.
Meanwhile something like Mongo or Axum or ?? or IDL would do this
naturally (make good scientific charts instead of bubble gum
candy/girlie/kiddie charts).

What is the best option for me? Do I go with a simple template a
consultant has worked out (speak up please), an excel add-in (which
one?), or do I really need to ditch excel unless all I was doing was
adding 2+2? I'd prefer not to have to toss excel and am hoping there
is a charting add-in I can buy.

Jason Taylor


--
jasonataylor
------------------------------------------------------------------------
jasonataylor's Profile: http://www.excelforum.com/member.php...o&userid=37102
View this thread: http://www.excelforum.com/showthread...hreadid=568421

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default Scientific charts: what is the best add-in or package for getting sane ones?

"jasonataylor"

wrote in message
news:jasonataylor.2c0yhi_1154710209.2738@excelforu m-nospam.com...

I need a normal scientific chart. You know, the ones with
axes on the
right, left, top, and bottom sides. I think I did this once
before and
it took an hour, since I had to trick excel into thinking i
had about
four different sets of data, most of which were fake. It was
insane.
Meanwhile something like Mongo or Axum or ?? or IDL would do
this
naturally (make good scientific charts instead of bubble gum
candy/girlie/kiddie charts).

What is the best option for me? Do I go with a simple
template a
consultant has worked out (speak up please), an excel add-in
(which
one?), or do I really need to ditch excel unless all I was
doing was
adding 2+2? I'd prefer not to have to toss excel and am
hoping there
is a charting add-in I can buy.

Jason Taylor


First, I would debate your use of "normal" scientific chart. In
a long career I never needed to use one such as you describe.
You might achieve what you want with Excel but there are many
programs at a great range of prices. One relatively cheap one is
PsiPlot. However, if you are actually engaged in research it
might be possible to get your employers to buy a more elaborate
program for you. At a university they may even have a site
licence for MatLab or SigmaPlot.



--
James Silverton
Potomac, Maryland

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Scientific charts: what is the best add-in or package for getting sane ones?


James Silverton Wrote: [color=blue]
"jasonataylor"

wrote in message
news:jasonataylor.2c0yhi_1154710209.2738@excelforu m-nospam.com...

I need a normal scientific chart. You know, the ones with
*axes *on the
right, left, top, and bottom sides. I think I did this once
before and


Sorry, I meant *tickmarks*, not axes (though I love those as well). So
I want a plot like the one he

<img
src="http://132.248.1.102/~morisset/idl_cours/IDL/images/sin2.gif".



First, I would debate your use of "normal" scientific chart. In
a long career I never needed to use one such as you describe.


Ok I took your advice and checked out Psiplot just now. But the
samples at I saw on the company's webpage did not have tickmarks on the
top or right. It isn't clear to me that the program has this feature.
Cost isn't an issue to me.

Jason



--
jasonataylor
------------------------------------------------------------------------
jasonataylor's Profile: http://www.excelforum.com/member.php...o&userid=37102
View this thread: http://www.excelforum.com/showthread...hreadid=568421

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default Scientific charts: what is the best add-in or package for getting sane ones?

Hello, jasonataylor!
You wrote on Fri, 4 Aug 2006 15:59:53 -0400:

j James Silverton Wrote:
?? "jasonataylor"
??
?? wrote in
?? message news:jasonataylor.2c0yhi_1154710209.2738@excelforu
?? m-nospam.com...[color=blue]
??
?? I need a normal scientific chart. You know, the ones
?? with *axes *on the right, left, top, and bottom sides. I
?? think I did this once before and
??
?? Sorry, I meant *tickmarks*, not axes (though I love those
?? as well). So I want a plot like the one he
??
?? <img
?? src="http://132.248.1.102/~morisset/idl_cours/IDL/images/s
?? in2.gif".
??
?? First, I would debate your use of "normal" scientific
?? chart. In a long career I never needed to use one such as
?? you describe.
??
?? Ok I took your advice and checked out Psiplot just now.
?? But the samples at I saw on the company's webpage did not
?? have tickmarks on the top or right. It isn't clear to me
?? that the program has this feature. Cost isn't an issue

?? ?? to me. ??

It's been a while since I last used PsiPlot but I think it will
do what you want, judging by some of the pictures in the User's
Guide. However, if cost does not matter, I think you might be
better to investigate SigmaPlot, which *is* very widely used in
science. I used it myself when I was a working scientist but it
would be an expensive luxury since my retirement :-)

You can get a 30-day trial of SigmaPlot:
www.systat.com/products/sigmaplot/ and it's supposed be
"integrated" with Excel. I don't know how much it costs but it
is certainly a program that sells site licences.

Best wishes,


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default Scientific charts: what is the best add-in or package for getting sane ones?

Jason -

I put together an example for you, available for download from
http://www.mikemiddleton.com (lower left corner of that web page).

It's an XY (Scatter) chart, using a dummy second data series for secondary
axes. You can select each chart object and see how things are formatted.

- Mike

"jasonataylor"
wrote in message
news:jasonataylor.2c17a5_1154721611.3038@excelforu m-nospam.com...[color=blue]

James Silverton Wrote:
"jasonataylor"

wrote in message
news:jasonataylor.2c0yhi_1154710209.2738@excelforu m-nospam.com...

I need a normal scientific chart. You know, the ones with
*axes *on the
right, left, top, and bottom sides. I think I did this once
before and


Sorry, I meant *tickmarks*, not axes (though I love those as well). So
I want a plot like the one he

<img
src="http://132.248.1.102/~morisset/idl_cours/IDL/images/sin2.gif".



First, I would debate your use of "normal" scientific chart. In
a long career I never needed to use one such as you describe.


Ok I took your advice and checked out Psiplot just now. But the
samples at I saw on the company's webpage did not have tickmarks on the
top or right. It isn't clear to me that the program has this feature.
Cost isn't an issue to me.

Jason



--
jasonataylor
------------------------------------------------------------------------
jasonataylor's Profile:
http://www.excelforum.com/member.php...o&userid=37102
View this thread: http://www.excelforum.com/showthread...hreadid=568421





  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Scientific charts: what is the best add-in or package for getting sane ones?


Jason -

I put together an example for you, available for download from
http://www.mikemiddleton.com (lower left corner of that web page).

It's an XY (Scatter) chart, using a dummy second data series for
secondary
axes. You can select each chart object and see how things are
formatted.

- Mike

Thanks Mike. I had done this a long time ago but totally forgotten
how. Now that I've downloaded your sample, I realize and recall that
one issue (aside from the annoyance of getting it setup), is that the
dummy series ranges usually have to be manually adjusted. For
instance, if you have 3 series, you need to make the one that has the
largest x range be selected if you are using the auto-range feature.
But I can definitly deal with that. It would be much, much less of a
pain than re-learning sigmaplot. Thanks.

Jason Taylor


--
jasonataylor
------------------------------------------------------------------------
jasonataylor's Profile: http://www.excelforum.com/member.php...o&userid=37102
View this thread: http://www.excelforum.com/showthread...hreadid=568421

  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Scientific charts: what is the best add-in or package for getting sane ones?


In case anyone comes across this thread, I just wanted to post that I've
finally found the original answer I was looking for. It is 'DPlot'
(http://dplot.com/). It does everything. It appears as a tab in
Excel, so you can just highlight data and click to plot. Very light,
both in price (<$40) and size/ram (~3 meg download). Could be slightly
more user friendly, but this was exactly what I was looking for. If
you need to plot some non-business stuff from an Excel doc and don't
have all day log to play around with tricking Excel, this should work.

:)


--
jasonataylor
------------------------------------------------------------------------
jasonataylor's Profile: http://www.excelforum.com/member.php...o&userid=37102
View this thread: http://www.excelforum.com/showthread...hreadid=568421

  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default Scientific charts: what is the best add-in or package for getting sane ones?

Hello, jasonataylor!
You wrote on Tue, 22 Aug 2006 20:20:47 -0400:

j In case anyone comes across this thread, I just wanted to
j post that I've finally found the original answer I was
j looking for. It is 'DPlot' (http://dplot.com/). It does
j everything. It appears as a tab in Excel, so you can just
j highlight data and click to plot. Very light, both in price
j (<$40) and size/ram (~3 meg download). Could be slightly
j more user friendly, but this was exactly what I was looking
j for. If you need to plot some non-business stuff from an
j Excel doc and don't have all day log to play around with
j tricking Excel, this should work.
j :)

Their web page makes it look quite attractive tho' I am not in
the market for such software at the moment. Thanks for bringing
it to my attention!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple charts similar size? [email protected] Charts and Charting in Excel 2 March 10th 06 06:16 PM
Pasting worksheet with embedded charts FishMan Charts and Charting in Excel 2 October 5th 05 02:26 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
An additional charts package? [email protected] Excel Discussion (Misc queries) 2 January 22nd 05 08:49 PM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"