Can someone give me step by step instructions on how to make a best fit line graph on Microsoft 2003 Excel?

Question

Be Detailed please.
Will these be the same steps for vista to? If not, then Best Answer goes to the one who can give step by step instructions on both 2003 and Vista!
Steps should be fairly easy to follow!

Answer 1

Try this in both versions. Sometimes newer programs retain older commands.

Type the Excel table.
Select the table - your headings and data.
Click Insert, click Chart.
Answer the Chart Wizard.

You might also find some help here:
http://office.microsoft.com/en-us/excel/FX100646961033.aspx

http://office.microsoft.com/en-us/excel/FX100646951033.aspx

Answer 2

right here you flow. a million. Have archives in 5 columns, considering which you desire 5 traces. each and each column would desire to have a header asserting what it represents. you have gotten a column to the left of the information expressing if the values represent the information at a definite evaluate time or something. 2. spotlight the entire table of archives. 3. close to the authentic of the demonstrate screen is a Toolbar called the same old Toolbar. it extremely is the Toolbar with the Print button, the Undo button, and so on. in direction of the a ways good hand ingredient of that toolbar you will desire to confirm a button with something on it that feels like a graph. click on that button to open the Chart / Graph Wizard. 4. then you definately will see a itemizing of chart varieties you are able to choose from. At this factor it is not considerable in case you opt for line graph or bar graph it extremely is in certainty a similar training from right here. opt for Line Graph. 5. as quickly as you opt for line graph you will see 7 or 8 options of what you opt for your line graph to look like. p.c.. one. 6. click on the subsequent button. 7. then you definately will see a tiny pattern of what the chart feels like. if your archives replaced into in columns as I pronounced, verify the "sequence In" bullet is next to Columns. if your archives replaced into in Rows, then verify the "sequence In" bullet is next to Rows. 8. click next. 9. the subsequent area provides a brilliant gamble to flow right into a identify on your chart, and to call the X & Y axis of the chart. Fill that archives in the traces presented in case you opt for. 10. click next. 11. Now you get to tell the wizard in case you opt for the graph placed in the present worksheet ("As merchandise In"), or as yet another worksheet (all in a similar workbook of direction). 12. click end. If the chart feels like what you opt for, then super. If no longer, good click someplace in the chart (no longer on a line or a bar however) and you will obtain some thoughts like "Chart sort", "Chart thoughts", and so on. so which you would be able to alter the way it seems. The traces or bars will ususally arise with diverse colours immediately, yet you are able to adjust them by utilising good clicking on the traces or bars themselves and selecting "format archives sequence". desire this facilitates. Dave