473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Plotting 3 variables on 1 graph

11
Hello there,

I am trying to plot 3 variables on one graph (specifically flow rate, pressure and flow path diameter) with the x-axis being measured in units of time.

Since these all have different units of measurement and there is only a primary and secondary axis I don't know how to fit them all on one graph or if it is even possible to do so. The reason why I need them all on one graph is to compare the values with one another at specific times.

Does anyone have any solutions or suggestions to help me out? Thanks for your time.
Oct 5 '15 #1
1 3337
zmbd
5,501 Expert Mod 4TB
amwkl4
AFIK: There is really no easy way to do this in excel for a "scatter chart" to create one you have to have a very-good to masters grasp if VBA to do anything of even a moderate complexity.

There is a YouTube video from LearnChemE (This poppedup in one of my searches on critical vales (triple-point :) )YouTube-LearnChemE-3D Plots in Excel which shows how to use/create a surface chart. This may work for your needs.

There is however, a professor, W. Kamakura (click for Bio), with Rice University that has developed an add-in and a worksheet that will help. He has however, encrypted and password protected these files. Be advised we will not help anyone remove passwords nor encryption from such files.
In the Rice.edu personal pages you will find his offering (click thru the above link) or you can reach it directly here:
http://wak2.web.rice.edu/bio/WagnerK...aDownloads.htm
((This link was verified today 2015-10-24.17:00GMT)

Your only other option is to purchase some rather expensive add-in or software from a commercial site.

(I may update this post in a little bit... I haven't tried this in Excel2013 so there maybe something I've missed)
Oct 24 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: jrlen balane | last post by:
i'm going to use now the matplotlib in plotting a graph. i'm currently using python 2.3(enthought edition) on win 2000/xp. i'm using boa constructor on the GUI part. i am using an...
11
by: Chapman | last post by:
Is it possible to plot the graph as an output of my program in C? It can be a simple graph as quadratic curves for example or a correlation between 2 variables only. Thanks
1
by: wayne | last post by:
i want to plot a line graph. The values that I obtain are the RGB value of a TIFF image. i m plotting RGB values vs value(1,2,3..) so when generated the RGB values, there will b a column of values...
3
by: i | last post by:
Hi, I'm working with an array of nodes, numbering roughly in the thousands. Each node has at least one, but up to four, references to another node - North, South, East, or West. I'm trying to...
7
by: diffuser78 | last post by:
My python program spits lot of data. I take that data and plot graphs using OfficeOrg spredsheet. I want to automate this task as this takes so much of time. I have some questions. 1. Which is...
5
by: Narendar123P | last post by:
Hi all, I am trying to plot a graph in excel file using C#.Net. I am using the name space excel . If my graph has one series(2 columns), i am able to draw the graph. if my graph has two series(4...
8
by: Adrian | last post by:
Having plotted a graph from x,y co-ordinate to x,y co-ordinate, the graph disappears immediately (after the last plot). Writing " " to a label, in between subsequent plots, solves this problem....
6
by: gubbachchi | last post by:
Hi all, I have got a problem with plotting bar graph using GD. I am learning GD now. I have written the code for basic bar graph with one bar. What I need is, scale on Y-axis i.e. divisions on...
2
by: Durand | last post by:
Hi, I'm trying to plot a simple graph against date or time using matplotlib. I've read about date_plot but I'm not really sure how to use it. At the moment, I have some data arranged into lists,...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.