Sitting at home trying to create a graph, If anyone out there who is good at this, and a good teacher, is willing to help me, please say so here and/or email me, thanks!!! I have tried the chart wizard thing, but it won't do what I want!
2006-09-28 03:11:31 · 11 answers · asked by dorothy 4 in Computers & Internet ➔ Software
Thanks to everyone who answered, you're all v kind, and Iain, you're a total legend - that is precisely what I want, just couldn't find a decent tutorial online. THANK YOU!!
2006-09-28 03:26:00 · update #1
http://phoenix.phys.clemson.edu/tutorials/excel/graph.html
2006-09-28 03:19:40 · answer #1 · answered by Anonymous · 2⤊ 0⤋
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.
2016-03-18 02:17:37 · answer #2 · answered by Anonymous · 0⤊ 0⤋
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.
2006-09-28 03:19:38 · answer #3 · answered by Anonymous · 0⤊ 0⤋
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.
2006-09-28 03:19:33 · answer #4 · answered by sarah c 7 · 0⤊ 0⤋
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.
2006-09-28 03:23:52 · answer #5 · answered by Keroppi 1 · 0⤊ 0⤋
Click on graph button on top. select x and y values in your sheet.
2006-09-28 03:19:08 · answer #6 · answered by iyiogrenci 6 · 0⤊ 0⤋
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
2006-09-28 03:21:35 · answer #7 · answered by p34nu7bu773rj3lly7im3 2 · 0⤊ 0⤋
Click on the help button
2006-09-28 03:20:30 · answer #8 · answered by Maurus B. 3 · 0⤊ 0⤋
give some more info which part you don't understand.
2006-09-28 03:23:30 · answer #9 · answered by J 3 · 0⤊ 0⤋
difficult to explain from here
2006-10-01 04:07:28 · answer #10 · answered by Anonymous · 0⤊ 0⤋