Plotting Graphs in Excel | Functions of x and y

In summary, to plot a graph in Excel with f(g,h), where g is a function of x and h is a function of y, you can make a row of y values and a column of x values, create a table of f(x,y), and then insert a surface chart using the "Other Charts" option in Excel 2010 or the "Chart Wizard" in Excel 2003. For example, if g = sin(2x/pi), h = cos(3y/pi), and f = g * h, you can plot a graph with x and y values from 0 to 2pi in steps of 0.1.
  • #1
henil
18
0
Member warned about posting with no effort
Mod note:Combined two posts into one.

1. Homework Statement
f(g,h) such that g is a function of x and h is a function of y then how can i plot a graph in exccel

Homework Equations

The Attempt at a Solution

 
Last edited by a moderator:
Physics news on Phys.org
  • #2
Make a row of of y values and a column of x values
Make a table of f(x,y)
(Excel 2010:) Insert tab | Other Charts | Surface
(Excel 2003:) Click Chart wizard | Surface

Example: x and y from 0 to ##2\pi## in steps of 0.1. ##\ \ g = \sin(2x/\pi),\ \ h = \cos(3y/\pi),\ f = g * h ##


Surf.jpg
 
  • #3
thank u for your help
 
  • #4
can you please send me the detailed steps if possible ?
 

FAQ: Plotting Graphs in Excel | Functions of x and y

How do I plot a graph in Excel?

To plot a graph in Excel, follow these steps:

  • Enter your data into a spreadsheet
  • Select the data you want to graph
  • Click on the "Insert" tab at the top of the screen
  • Choose the type of graph you want to create from the "Charts" section
  • Your graph will appear on the spreadsheet

How do I edit a graph in Excel?

To edit a graph in Excel, follow these steps:

  • Double click on the graph to open the "Chart Tools" menu
  • To change the data, click on the graph and then click on the "Select Data" button in the "Chart Tools" menu
  • To change the layout or style of the graph, click on the "Design" or "Format" tabs in the "Chart Tools" menu

Can I add a trendline to my graph in Excel?

Yes, you can add a trendline to your graph in Excel by following these steps:

  • Right click on the data point in your graph and select "Add Trendline"
  • In the "Format Trendline" menu, select the type of trendline you want to add
  • Customize the trendline by adjusting the options in the menu

How do I change the axis labels in my graph?

To change the axis labels in your graph, follow these steps:

  • Click on the axis you want to change
  • Right click and select "Format Axis"
  • In the "Format Axis" menu, you can change the title, labels, and other options

How do I save my graph as an image in Excel?

To save your graph as an image in Excel, follow these steps:

  • Click on the graph to select it
  • Right click and select "Save as Picture"
  • Choose the file format you want to save it as and click "Save"

Similar threads

Engineering Graphing Shear and Moment using singuarity function in Excel
Replies
1
Views
2K
Comp Sci Orbit of Earth: Plotting Trajectory
Replies
6
Views
1K
Comp Sci Using Single Source Shortest Path Algorithm to find the longest path
Replies
4
Views
1K
Engineering Bode plot for active low pass filters
Replies
9
Views
3K
How can you modify Python code for effective graph plotting?
Replies
6
Views
381
Interpreting graphs from isentropic efficiency of a compressor lab
Replies
1
Views
2K
Plotting the waveforms of the harmonic components
Replies
4
Views
2K
How to find drag polar equation of Cl vs Cd graph
Replies
4
Views
8K
Problem with plotting a function in MATLAB
Replies
10
Views
2K
Solving for Minimum point Excel
Replies
2
Views
1K

Hot Threads

Recent Insights

Back
Top