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

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

View Full Document Right Arrow Icon
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:
Background image of page 1

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

View Full DocumentRight Arrow Icon
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:
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
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 Right Arrow Icon
Ask a homework question - tutors are online