Which software to use to create this graph?

  • Thread starter Thread starter sawtooth500
  • Start date Start date
  • Tags Tags
    3d Data Graph
AI Thread Summary
The discussion centers on visualizing a dataset with three variables: Time, Quantity 1, and Quantity 2. The user seeks a way to represent all three variables simultaneously, proposing a 2D line graph for Time and Quantity 1, with Quantity 2 represented as vertical bars. They are looking for software that allows easy data import from Excel or CSV files. Suggestions include using Desmos for 3D plotting and R, which is free and offers advanced graphing capabilities, although it has a steeper learning curve compared to Excel. The conversation highlights the ease of creating basic graphs in Excel while also acknowledging the potential of more sophisticated tools for enhanced data visualization.
sawtooth500
Messages
16
Reaction score
0
TL;DR Summary
Need a plot of 3 variables
So I have a dataset with 3 variables

-Time
-Quantity 1
-Quantity 2

Currently I have all the data in an excel sheet. So for example, I can easily in excel create a line graph that shows me quantity 1 on the Y axis and time on the X axis... however I want to see all 3 at the same time. So my idea is to take a 2D line graph, and add quantity 2 in the Z dimension and have it be represented as bars coming up (quantity 1 and 2 are all positive FYI).

I'm just a hobbyist so I have limited experience in this, and I'm just playing around, but what's a software platform that could do this for me? Preferably something I can just import the data into as an excel or CSV file? Thanks.
 
Physics news on Phys.org
It would be easy within Excel to make a two-line graph of Quantity 1 and Quantity 2 versus time (as the X-axis).
See this.

I have used R a lot in the past. It can be downloaded for free and has a good reputation within statistics and data analysis. It has good flexibility for graphing, but there is a lot more to learn that simply graphing within Excel.
 
A video on using Excel to make 3D charts:

 
  • Like
Likes FactChecker

Similar threads

Replies
5
Views
2K
Replies
4
Views
2K
Replies
2
Views
3K
Replies
2
Views
1K
Replies
3
Views
3K
Replies
1
Views
2K
Replies
5
Views
3K
Back
Top