What would you like to do?
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: 1. Type in all your information in Excel. 2. Highlight all the data you want to include …in your bar graph. 3. Click Chart... on the Insert menu. 4. Follow the directions in the window to choose the chart type, source data, options, and location (as object or new sheet). That 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.
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
ENter the data into excel under 2 different tabs, SO your x values on one column and your y values on the next. Then highlight all of your data and hit 'insert' th…en select charts. Then you pick the line graph of your choice and VOILA!!
Clue: A Cross____ is a popular type of puzzle (4 letters). Excel doesn't fit try WORD. A Word table is much better for creating a crossword. In Word you can make the who…le thing in to a form, fillable on-line while ensure that input is restricted to one letter per square in upper case. Alternatively you can embed hidden answers and send the document to friends. If you must use Excel use alternate rows for numbers and letters. To make a 13x13 grid, format 13 columns to a width of 4.4. format 26 rows alternately to height of 9 or 15. Each square of the crossword grid will be two cells high to be capable of accommodating a number and a letter. Within the grid area the cells in the smaller rows should be formatted to use 8 Point Courier New and aligned top right. In the larger rows cells should use Arial 16 and be aligned to 'center' both vertically and horizontally. Put borders to define the grid squares, remembering that vertically there are two cells to a square. Hide the gridlines on the worksheet. Create black squares by changing the pattern in the two cells of a square to black. Either choose a grid pattern first and find words and clues to fit or make up the pattern as you go along. Fill in the answers and make sure you number each square correctly. Save the result and then remove the answers and save the file under a different name.
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 can only make it by hand if you don't want to use excel
whaty should ti do fi i see some one scarse some
As many as the memory in your computer can store. The number of worksheets in each workbook is limited only by the amount of memory available.
Lots of things can be used in Excel to make something stand out from the rest. You can change the colors, increase the font size, use a different font, put borders around thin…gs, bold them, underline them, italicize them and more. There is also an Autoformat feature which allows you to apply pre-designed styles to your spreadsheet. However, for the Crossword Puzzle Challenge, your answer is "bold".
DISADVANTAGE: 1. We need to look up based on more than one column 2. We're getting an #N/A though the key is valid 3. We're confronted with the Zoolander… problem
First, you enter your data into the entry boxes on the spreadsheet. You highlight it all but the title. Then, go up to the taskbar and choose ChartWizard. Chhose the type of g…raph you would like (In this case, bar) and enter the data it asks for from there.
Used copies of Microsoft Excel software are available for purchase on eBay. It is not however fine for one to pass an Office licence key from one to another.
To use the entire box in Microsoft Excel 2007: click the Home tab, click Format in the Cells group and search for the current worksheet.