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
SUMMARY

The discussion centers on creating a 3D graph to visualize three variables: Time, Quantity 1, and Quantity 2. The user seeks software that allows importing data from Excel or CSV files for this purpose. Recommendations include using Desmos for 3D plotting and R for its robust graphing capabilities, although R requires a steeper learning curve compared to Excel. The user emphasizes the need for a platform that can effectively represent Quantity 2 as bars in a 3D space alongside a line graph.

PREREQUISITES
  • Basic understanding of data visualization concepts
  • Familiarity with Excel for data handling
  • Knowledge of CSV file formats for data import
  • Introductory knowledge of R for advanced graphing techniques
NEXT STEPS
  • Explore Desmos for creating 3D graphs and its functionalities
  • Learn R's ggplot2 package for advanced data visualization
  • Research tutorials on creating 3D charts in Excel
  • Investigate other data visualization tools like Plotly or Tableau for 3D plotting
USEFUL FOR

Hobbyists, data analysts, and anyone interested in advanced data visualization techniques, particularly those looking to represent multiple variables in a 3D format.

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
2K
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
2K
Mathematica Mathematica - How to Graph Direction Fields of ODEs?
  • · Replies 9 ·
Replies
9
Views
2K
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