who knows how to do excel homework

profileSaud_ar
graph_hints_revised_spring_2016.doc

Here are some quick steps to help you graph.

1. Highlight the data you want to graph, including the row descriptions and the numbers. Make sure you did not type across empty columns to use this method.

2. Hit F11 (on the top row of keys). A bar graph will appear on its own tab and a new spreadsheet will automatically be created called “Chart”.

3. To change the bar graph to a 3-D pie graph, click on the Change Chart Type in the menu bar at the top of the page. Click on the pie graph on the list at the left and then choose one of the 3-D pie graphs from the options that pop up.

4. Next, click on Chart Layouts in the menu bar at the top of the page and choose the option that presents the data according to the excel instructions. For example, if the instructions say to include data labels and percentages, then you would choose the first option under Chart Layouts. This will also automatically delete the legend.

5. To add a heading to your chart, just click on the Chart Title box and start typing. Make sure your heading has all three lines: company name, title of chart, and date.

6. To change the number of decimal places for the percentage labels in the graph, just click on Layout in the menu bar at the top of the page, then click on Data Labels, choose the “More Data Labels Options” at the bottom of the pop-up menu, then click on “Number” in the left menu. Now you can change the number of decimal places or the formatting of the numbers.

7. You can make other pieces of the graph look prettier by (left) double clicking and modifying each piece or by just playing around with some of the other menu options in the tool bar.

8. You can make the graph larger by clicking on the graph so it appears in a box then right click on the corner of the box (you should see a double arrow) and drag it up and to the right. If you wish to move the entire graph to a different location, right click on the graph and drag it to where you want it to be. Make sure the graph is not too small for the page. It should be large enough to easily read all of the data included in the graph.

9. You can rotate the graph so that some areas of the graph that are small will show up better by right clicking on the graph and then clicking on “3-D View.”

10 Don’t be afraid of making a mistake. If you do, just use the undo button on the tool bar or go to Edit/Undo in the pull down menus.

Good Luck and Have Fun!