answersLogoWhite

0

How do you make scatter-graphs using Excel 2007?

Updated: 8/18/2019
User Avatar

Wiki User

14y ago

Best Answer

Use a scatter plot graph to represent the correlation between two different variables. Here are some steps to make a basic scatter plot graph.

  1. Get your data into an Excel spreadsheet (type, copy, link, etc.).
  2. Highlight the data you want to display on the graph.
  3. Select the Insert tab from the ribbon bar.
  4. From the Charts section, click on Scatter and select the Scatter with only Markers option.
  5. Move, format, and adjust the chart to meet your needs.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you make scatter-graphs using Excel 2007?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is an excel query?

Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.


What is a chart tool on Excel?

It allows you to make charts or graphs. You will find it in the Charts section of the Insert Ribbon in Excel 2007.


What is the three letter comn in the Microsoft Excel 2007?

It is not clear what "comn" means. Please ask this question again using words that make it clear what you want to know.


Can you make Excel 2007 look like the old Excel?

There are some downloadable tools on the web which recreate the old or 'classic' Excel toolbar in Excel 2007. One such example you might want to take a look at can be found at http://www.download.com/Classic-Menu-for-Excel-2007/3000-2077_4-10637173.html Regards, Jake Courtesy of www.Excel-Expert.co.uk


How do you make a webpage using the MSExcel?

You cannot make a web page with Microsoft Excel.


What application in Microsoft Office 2007 should you use to make a bar graph?

Excel


What is the size of an Excel sheet?

The max columns on an excel 2007 sheet are 16k. The max rows are 1M. In excel 2003 the max columns are 256 and max rows of 64k.


How play game in Excel 2007?

There are no hidden games in Excel since Excel 2000. So there are none in Excel 2007. You can use a spreadsheet for all sorts of things, so you could play some games using numbers and formulas, but you would have to make them up yourself, and Excel isn't really for that kind of thing, so it could be tedious trying to do so and what you would come up with would not be very exciting. You could do simple number guessing games for example.


How many users can access and make changes to a file at the same time and excel 2007?

100


What are the benefits in using Excel in bakery?

it can make your work easy 2 calculate....^_^ ^_^


When and why are cells selected in Microsoft Excel?

Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.Cells are selected constantly in using Excel. To enter anything into a cell it needs to be selected. To do things like format cells, they need to be selected. To do things like make charts, cells need to be selected. Cells are fundamental to using Excel, so anything you do with cells needs them to be selected.


How do you make excel 2007 the default when opening files?

whaty should ti do fi i see some one scarse some