MICROSOFT EXCEL I need help, please, from someone who knows how to translate spreadsheet data into graphs.?

http://phoenix.phys.clemson.edu/tutorials/excel/gr...

Start new workbook. On sheet 2 enter your values in contiguous cells, in one column. Highlight all the cells you have just entered values into. Use the Insert | Name | Define Menu/Options or the 'name box' to the left of you function bar and type in a name for list of values you have just typed in. E.g. "Mylist" Now go to Sheet 1. If you cannot see the Visual Basic Menu, right click on the tool bar or use the Insert, Toolbars and in each case select Visual Basic. Now on this tool bar click Design mode, and Toolbox. Find the Combo Box Tool, in the tool box and click on it. 'Draw' the combo box onto the sheet where you want it. Now, again in the toolbox, with the Combo Box still selected, find and click the Properties box. In the properties window, find the ListFillRange property (this appears in the left hand column) In the corresponding right-hand column, type in the name of the name of your list - "Mylist" and click enter. Now unclick Design mode, and Toolbox and also close the property box by clicking on the 'x' - close window button. Now click on the Visual Basic Editor buton on the Visual Basic oolbar. In the Project Window, double click on Sheet 1 In the left hand dropdown of the window just opened, select Combobox1. Complete the code so it looks like the following: Private Sub ComboBox1_Change() Range("A1").Cells.Value = ComboBox1.Text End Sub This will put the selected value into Cell A1. Excel is very powerful, and there are many options, properties and you must be careful when doing the things I have described. I am using Excel 2003, and I know the 'tools' and other items improve slightly as time goes by and new versions are released. To do this properly, I would get a book on VBA with a focus on VBA for Excel. Anyway, hope this helps.

Chart wizard won't work unless you have higlighted everything that you want included in the graph, including headings. For example, if you are doing a pay thing, highlight staff names, months and amounts paid, then hit chart wizard. It will work fine.

What is it you are trying to do? We need more info.

Do you know how to use the wizard? You would select Graph as the first option on the wizard. From then on you'd be editing your graph.

You can click on 'Insert' from the tool bar on top of the page. Then select 'Chart..'. Choose the Chart/Graph you want. Then follow the instruction.

Click on graph button on top. select x and y values in your sheet.

omg yea this is rly easy just select lik Insert -> chart and follow the steps its rly easy....

just as long as u actually understand linear algebra that it lol

Click on the help button

give some more info which part you don't understand.

difficult to explain from here