Creating Graphs and Charts with Excel Creating and editing tables 1. Add your columns as you would like the data to be plotted on your bar graph, line graph, pie graph, or x-y scatter plot:
2. Select all of the contents of your table and choose…
3. When formatting is selected, the font, color, size, shading and borders are automatically added to all portions of the table:
Item Budget Allocation
Computers Printers Software Peripheral Devices Internet
$25,000.00 $3,000.00 $3,500.00 $1,200.00 $3,000.00
Creating charts and graphs from your data 1. Continue to highlight all of the contents of your data that you would like to graph: 2. Choose:
D:\Docstoc\Working\pdf\3a12ce92-d952-4973-a94e-d05315a072a8.doc
3. Choose the type of chart or graph that you would like to create:
4. Skip Step 2 of 4. 5. Type the title that you would like to appear at the top of the chart/graph:
6. Determine the location of the legend if you choose to have one:
D:\Docstoc\Working\pdf\3a12ce92-d952-4973-a94e-d05315a072a8.doc
7. Determine the labels that you would like to have appear on the chart/graph:
8. Identify the location of the chart within the existing workbook:
D:\Docstoc\Working\pdf\3a12ce92-d952-4973-a94e-d05315a072a8.doc
Editing your Graph/Chart 1. Double click on any portion of the graph/chart to alter its formatting:
2. You can also change the angle of the specific details of the graph layout, depending upon the type of graph you chose in step one.
3. You can move any one of the chart/graph components away from the rest to show a specific highlight or focus:
D:\Docstoc\Working\pdf\3a12ce92-d952-4973-a94e-d05315a072a8.doc