In search of a Graphing Program for Excel data

Click For Summary

Discussion Overview

The discussion centers around finding a suitable graphing program for visualizing data from an Excel sheet containing 200 points, specifically for a school essay. Participants explore options for graphing in quadrant 1 and the ability to graph a circle with a radius of 20.

Discussion Character

  • Exploratory, Technical explanation, Debate/contested

Main Points Raised

  • One participant seeks a free graphing program that can handle data from Excel and graph specific requirements, including a circle in quadrant 1.
  • Another participant suggests using a connected line scatter plot in Excel as a potential solution.
  • A participant mentions that the professor advised against using Excel's graphing capabilities, indicating a preference for more specialized software.
  • One participant reports successfully using Maple 18 to graph the data, noting the ease of copying data into a matrix for plotting.
  • Additional software options mentioned include gnuplot and Grace, with links provided for accessing qtgrace and xmgrace.

Areas of Agreement / Disagreement

Participants express differing opinions on the suitability of Excel for graphing scientific figures, with some advocating for alternative software while others suggest Excel's scatter plot feature.

Contextual Notes

There is no consensus on the best graphing program, and participants have varying experiences and preferences regarding software capabilities and usability.

Who May Find This Useful

Students or individuals looking for graphing software options for scientific data visualization, particularly those with experience in Excel and alternative graphing programs.

RJLiberator
Gold Member
Messages
1,094
Reaction score
63
Here is essentially what I need to do for a school essay:

I have an excel sheet with 200 points (x corresponding to A1 column values, y corresponding to B1 column values). I need to find a way to transfer this to a graphing program in quadrant 1 (all x,y coordinates are >= 1 and less than or equal to 20.

I need to be able to graph the circle with radius 20 (just the quadrant 1 selection of it) here as well.

A good graping program to do this was brought up b the teacher --> KaleidaGraph. However, it cost $150.

Is there anything free-graphing program that's able to do what I need? If not, what other programs out there, that cost money, are able to do this?

Thank you.
 
Physics news on Phys.org
RJLiberator said:
Here is essentially what I need to do for a school essay:

I have an excel sheet with 200 points (x corresponding to A1 column values, y corresponding to B1 column values). I need to find a way to transfer this to a graphing program in quadrant 1 (all x,y coordinates are >= 1 and less than or equal to 20.

I need to be able to graph the circle with radius 20 (just the quadrant 1 selection of it) here as well.

A good graping program to do this was brought up b the teacher --> KaleidaGraph. However, it cost $150.

Is there anything free-graphing program that's able to do what I need? If not, what other programs out there, that cost money, are able to do this?

Thank you.

Is there a reason you don't just use a (connected line) Scatter Plot in Excel? :smile:
 
  • Like
Likes   Reactions: RJLiberator
Well, the professor mentioned that Excel's graphing program isn't the best option.

I would like a program that is better suited to graphing scientific figures.
 
I ended up using Maple 18 to graph. Things went exceedingly well.

I copied my two columns from excel into a matrix and used that to display my points, and another plot of a circle to display what was needed.
 

Similar threads

  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
Replies
6
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 12 ·
Replies
12
Views
4K
Replies
11
Views
2K
Replies
7
Views
3K