What would you like to do?
How do you make scatter-graphs using Excel 2007?
Use a scatter plot graph to represent the correlation between two different variables. Here are some steps to make a basic scatter plot graph.
- Get your data into an Excel spreadsheet (type, copy, link, etc.).
- Highlight the data you want to display on the graph.
- Select the Insert tab from the ribbon bar.
- From the Charts section, click on Scatter and select the Scatter with only Markers option.
- Move, format, and adjust the chart to meet your needs.
4 people found this useful
Was this answer useful?
Thanks for the feedback!
Answer: Excel . You can do it in only 4 simple steps:\n. \n1. Type in all your information in Excel.\n. \n2. Highlight all the data you want to include in your bar graph.…\n. \n3. Click Chart... on the Insert menu.\n. \n4. Follow the directions in the window to choose the chart type, source data, options, and location (as object or new sheet).\n. \nThat should do it! But I only found this out on Microsoft Excel 2003. So, try my idea to see if it works. If not, pressing F1 will get you to the help pane. Type "chart" in the text box in the help pane, then press enter. It should take you to a list of topics. Click the topic describing how to create a chart. Please consider my help.
first make your graph with all the points and then once you've done that and you have your graph... double click on one of the scale values on either the x or y axis, look for… the 'scale' tab and check the box 'logarithmic scale'....hope it helps The above is incorrect. There is no option for log scale on the x axis. The data will have to be provided in in logarithmic scale for the x axis to depict it as such.
Select the values that you want to chart. Then on the ribbon go to the Insert tab and you can choose a line chart from there to create it.
Try the first link below, which shows you how to combine chart types to make new chart types. Alternatively you can use a ready made graph such as the ones at the second link …below which you can include on your website.
You get a pie chart up by going to insert, select pie chart, pick the style you want, then you will need to select the data for it to use.
You can do so quickly with the graphics wizard. It will guide you through the steps.
You can only make it by hand if you don't want to use excel
You click on the Chart Wizard button to start the process of making a graph.
whaty should ti do fi i see some one scarse some
It is like a COUNTIF which allows you to count things based on a condition. COUNTIFS will count the number of rows for which the range1 entry meets criterion1, the range2 ent…ry meets criterion2, the range_n entry meets criterion_n, and so on. So the difference is that COUNTIFS allows the criteria to involve more than one column or multiple conditions in one column, whereas COUNTIF can only use one condition.
Sure. Just click on the graph, then click and drag on one of the edge handles (either a small box in each corner, or a double-headed arrow when you hover over one of the graph… border lines). Repeat, as needed, to position the graph where you like.
Right-click on the graph and select Change Chart Type .
Because it is an easy tool for people to use and it is an application available in most offices. You alos can make graphs with the Calc application included with the free Open… Office program if you do not have access to Excel.
A circle graph is usually called a Pie or Donut graph. You highlight the data you want to graph and click on the type of graph you want to insert. You will find graphs on the …Instert Tab in the Graphs section. You can use Excel to make the following types of Charts and Graphs: . Column . Line . Pie . Bar . Area . X Y (Scatter) . Stock . Surface . Doughnut . Bubble . Radar
Press and hold Alt and then F4.
Select the data you want, remembering that a Pie Chart can only have one series. You can then either click on the Insert menu and pick Chart and then follow the steps to creat…e your chart, or click on the chart icon on the Standard toolbar.