Which software to use to create this graph?

In summary, the article discusses various software options for creating graphs, highlighting their features, ease of use, and suitability for different types of data visualization. It compares tools like Microsoft Excel, Google Sheets, Tableau, and R, emphasizing that the choice depends on the user's specific needs, such as complexity of data, interactivity, and presentation styles.
  • #1
sawtooth500
16
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
  • #3
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.
 
  • #4
A video on using Excel to make 3D charts:

 
  • Like
Likes FactChecker

Similar threads

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