SBS_Lab1_Step5b - Type in Total Profit: Click OK to close...

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

View Full Document Right Arrow Icon
Trendline Chart Steps 5b A. You should have a data set that includes total daily profit per item: B. Select the data you wish to chart, the dates and the Totals. Select non-contiguous cells by holding down the CTRL key: C. From the Insert Tab, go to the Charts Group and select the Line command: Select the 2-D line with markers option:
Background image of page 1

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

View Full DocumentRight Arrow Icon
From the Charts Design Tab, select Layout 3. Click on the Chart Title to edit and change it to say: Total Profit by Day. Edit the Legend. Right click on the Legend and choose the Select Data option:
Background image of page 2
In the Legend Entries (Series) dialog box, choose Edit:
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: Type in Total Profit: Click OK to close the Edit Series dialog Box and then OK to close the Select Data Source dialog box. Move the completed chart to a new sheet. Use the Insert Tab to add a callout that points to the highest daily sales. Label the callout Kick-Off Event. Your chart will look something like this: Format the horizontal axis alignment 270 degrees by right-clicking the axis: Select Alignment and change the Text Direction: Your chart will now look something like this:...
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_Step5b - Type in Total Profit: Click OK to close...

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