SBS_Lab1_Step5a

# SBS_Lab1_Step5a - Add a Chart Title From the Chart Tools...

This preview shows pages 1–6. Sign up to view the full content.

Step by Step Instructions Step 5a Create a Pie Chart Begin by extracting the data you will need for your chart. It is much simpler to work with the specific data you need. The Pie Chart you will create includes the Items and the percentage of sales. Select cells A5:A15 and cells P5:P15. Copy these cells and paste them into a new sheet, using the Paste Special command. Open the Insert Tab. Select the data in your smaller table and then select Pie from the Charts Group. Select 3-D Pie: A 3-D Pie Chart will be created:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Click on the Chart Tools Tab to modify the chart. In the Chart Layouts Group, click to see the options available to you. Locate the option that provides titles and percents:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Add a Chart Title. From the Chart Tools Tab, select Chart Title. Add a title above the chart. The Chart Title is automatically taken from the data headings. Change the title to make it more descriptive by clicking in the Chart Title textbox: Move the chart to a separate page. Right click on the Chart and select Move Chart: Move the chart to a separate sheet called Profits by Item: Add a graphic to point out the highest profit item. Open the Insert Tab, select the arrow shape: Click on the chart and draw the arrow shape. Use the Rotation handle to point the shape toward your chart: Right click on the arrow and select Edit text. Label the arrow, “Highest Profit Item”:...
View Full Document

## This note was uploaded on 03/24/2011 for the course BIS 155 taught by Professor Willox during the Spring '99 term at ITT Tech San Dimas.

### Page1 / 6

SBS_Lab1_Step5a - Add a Chart Title From the Chart Tools...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online