PC Review


Reply
Thread Tools Rate Thread

Can you display mathematical equations in Excel?

 
 
Angus
Guest
Posts: n/a
 
      20th Dec 2011
If so how would you do that. I tried making some data items, x and y,
in two columns and linking chart to the two columns - but it simply
joins the co-ordinates, eg is not smooth - and the placing of the x
and y axes is wrong. Is this they way to do it? Is there another
way?

Angus
 
Reply With Quote
 
 
 
 
JRosenfeld
Guest
Posts: n/a
 
      20th Dec 2011
Have you tried changing the graph type? there are several that do draw
curves through the points. Right click on the chart, click chart type..try
XYscatter

"Angus" <(E-Mail Removed)> wrote in message
news:da0f7a15-0b52-4a6a-8d57-(E-Mail Removed)...
> If so how would you do that. I tried making some data items, x and y,
> in two columns and linking chart to the two columns - but it simply
> joins the co-ordinates, eg is not smooth - and the placing of the x
> and y axes is wrong. Is this they way to do it? Is there another
> way?
>
> Angus



 
Reply With Quote
 
Xt
Guest
Posts: n/a
 
      21st Dec 2011
On Dec 21, 11:03*am, "JRosenfeld"
<jean.rosenf...@nospam.ukgateway.net> wrote:
> Have you tried changing the graph type? there are several that do draw
> curves through the points. Right click on the chart, click chart type..try
> XYscatter
>
> "Angus" <anguscom...@gmail.com> wrote in message
>
> news:da0f7a15-0b52-4a6a-8d57-(E-Mail Removed)...
>
>
>
> > If so how would you do that. *I tried making some data items, x and y,
> > in two columns and linking chart to the two columns - but it simply
> > joins the co-ordinates, eg is not smooth - and the placing of the x
> > and y axes is wrong. *Is this they way to do it? *Is there another
> > way?

>
> > Angus- Hide quoted text -

>
> - Show quoted text -


It isn't exactly clear what you want to do when you say "display
mathematical equations". If your aim is simply to illustrate graphs
of various types to students in a classroom then there are all sorts
of ways to make interactive graphs which will show the effect of, say,
changing the coefficients in y = Ax^2 + Bx + C. See
http://pt3.wikispaces.com/file/view/...ive_Graphs.pdf for a
simple example.

Email me if you are interested. I have many examples. xt
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:25 AM.