Which software to use to create this graph?

  • Thread starter Thread starter sawtooth500
  • Start date Start date
  • Tags Tags
    3d Data Graph
Click For Summary

Discussion Overview

The discussion revolves around the challenge of visualizing a dataset with three variables (Time, Quantity 1, and Quantity 2) in a 3D format. Participants explore various software options that can facilitate the creation of a 3D graph, particularly for users with limited experience.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant describes a dataset with three variables and expresses a desire to visualize them in a 3D graph format, specifically using bars to represent Quantity 2 alongside Quantity 1 and Time.
  • Another participant suggests using Desmos for 3D plotting, providing a link to the platform and additional resources.
  • A different participant mentions that creating a two-line graph in Excel for Quantity 1 and Quantity 2 against Time is straightforward, but also recommends R for more complex graphing needs, noting that it requires more learning compared to Excel.
  • A participant shares a video resource on creating 3D charts in Excel, indicating that it may be a viable option for the original poster.

Areas of Agreement / Disagreement

Participants present multiple software options for creating the desired graph, indicating a lack of consensus on the best approach. Some suggest Excel, while others propose Desmos and R, reflecting differing opinions on ease of use and capabilities.

Contextual Notes

Participants have not fully explored the limitations or specific requirements of each software option, such as compatibility with data formats or the learning curve associated with more advanced tools like R.

Who May Find This Useful

Individuals interested in data visualization, particularly those with datasets involving multiple variables and seeking user-friendly software options.

sawtooth500
Messages
16
Reaction score
0
TL;DR
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:

 
Reply
  • Like
Likes   Reactions: FactChecker

Similar threads

Mathematica Why Is Mathematica Not Graphing This 3d Graph Correctly?
  • · Replies 5 ·
Replies
5
Views
3K
Mathematica Mathematica 3D Graphing (3D Plot) Issue
  • · Replies 4 ·
Replies
4
Views
2K
MATLAB Getting Error When Plotting Graph (Using Python w/ matplotlib.pyplot)
  • · Replies 5 ·
Replies
5
Views
3K
Mathematica Mathematica - How to Graph Direction Fields of ODEs?
  • · Replies 9 ·
Replies
9
Views
3K
MATLAB How to extract data from existing JPEG/TiFF graph?
  • · Replies 2 ·
Replies
2
Views
3K
MHB Normal distribution graph P(a<x<b)
  • · Replies 2 ·
Replies
2
Views
1K
Software for creating graphs for presentations
  • · Replies 3 ·
Replies
3
Views
3K
Graphing Data in Excel: Error Bar Confusion
  • · Replies 1 ·
Replies
1
Views
2K
MATLAB Numerical approximation of the area under curve
  • · Replies 5 ·
Replies
5
Views
3K
In search of a Graphing Program for Excel data
  • · Replies 5 ·
Replies
5
Views
2K