Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Excel and Mathematics

Feb 25, 2006 12:19PM PST

A friend asked me how she can draw graphs (plot and draw) to help her daughter in her mathematics class, involving algebra, trigometry, calculus, etc., to illustrate mathematical functiions, etc. She will need to draw more than one graph on a ''chart'' to show where equations intersect, drawing ''tangents to a curve'', to show maximum and minimum points, etc. I suggested MS Excel, not actually knowing how it can be done. I would be grateful for any ideas to pass on, whether on how to do it with MS Excel or with another better program, maybe one specificly for the purpose - maybe a web site ? Thanks.

christy

Discussion is locked

- Collapse -
(NT) (NT) BUMP
Feb 26, 2006 5:45AM PST
- Collapse -
Excel graphs
Feb 27, 2006 4:55AM PST

Hi Christy, sorry for the delay.

Excel will certainly draw graphs, as long as it has two sets of numbers to work from.

I'm not sure what else I can say except the best way to learn is to try it. The two sets of numbers are best in column format, (although any sequence will do), eg;

Month Amount
Jan --- 10
Feb --- 20
Mar --- 40
Apr --- 05
May --- 17
Jun --- 28

etc

When the numbers are complete, click the Chart Wizard on the toolbar, and go step by step through creating a graph of the figures. The wizard first asks what type of graph is wanted, eg in mathematical function cases it is probably Line graphs.

The next step is defining the data ranges for the graph. This is from the figures that have been entered. The first Data Range is confusing, so click the Series tab. Then click ''Add'' to add a series, give the series a name, then in the Values box, select the range of values entered under Amount. The easy way to do this is to highlight on the spreadsheet the whole column of figures entered.

Then in the Category (X) box, highlight the months column. The Next windows give further choices to label axes, title the graph, and where to place the graph.

It is far easier to try it out, experiment and if you make mistakes go back and try and sort them out, than it is trying to explain it in a forum.

Is this what you meant?

Mark

- Collapse -
Graphs with MS Excel.
Feb 28, 2006 7:19AM PST

Thanks for the reply, Mark.

My friend exprimented as you suggested, and found that she was able to draw simple graphs, but was hoping for a more simple program. I think she has achieved hat she set out to do.

christy