Right click on the chart, and select Format Chart Area. Be sure the plot takes up most of the space.You can adjust the axis properties by right clicking on the axis, and select Format Axis. Make any final adjustments to make the graph clear and readable. Move objects around so they are clearly visible.If you want to discuss the R2 value, select it as well. To show the equation of the line (y=mx +b), check the "Show Equation" box. If the plot is to go thru the origin, check the "Set Intercept" box, and enter 0 in the box. To draw a straight line thru the data, right click on a data point, and select "Add Trendline".Don’t forget the units! (Use rotated on the vertical axis.) Also, select Chart Title to add a title for the entire chart. Click on Axis Titles in the Labels submenu. At the top, there will be a green area labeled Chart Tools.If X and Y are backwards, re-select the values on this window.) For example, on a density plot the mass should be on the Y-axis, and volume on the X-axis. (If you put Y as column A and X as column B, this will be done automatically. Make sure the proper X and Y values are selected. Click on Series1 (on the left) if it is not already selected, and press the Edit button just above it. Right click on the graph, and select Select Data.Select the first option, scatter with only markers. (Click in a corner and drag the mouse until all boxes are selected.
Set the data range by selecting all the data.To show a linear relationship using Excel, such as density, complete the following steps: How to Make a Linear Plot using Microsoft Excel 2010 The graph will then appear on your worksheet.To Make a Linear Plot using Microsoft Excel Select all the cells you have entered data into, including your header.Ĭlick the "Insert" tab, click "Scatter" in the Charts area and then click the type of graph you need. As you do this, the column will automatically populate with the solutions to each function, based on the value of x in column A. Make sure each of your x values has a corresponding function to the right of it. Select cell B2 and then drag to copy the formula down the column with the same method you used in step 2. Replace "50" with your sale price and "3500" with your costs. For example, to determine the number of sales you need to make of a certain product to cover costs, you could use: Type an equal sign "=" into cell B2 and then type your formula directly after it, without leaving a space. Select both of these cells and then click and drag the small black square in the lower-right corner of the selection area downwards until you have as many values as you want to plot.
For example, if your intervals are whole numbers, you might start by entering "1" into cell A2 and "2" into cell A3. Enter the first and second interval of your input variable (for example, "x" or "sales"), which you'll use to plot the function.
0 kommentar(er)
