Excel
 Assignment 6 - Working with Charts

Excel allows you to track and work with substantial amounts of data. At times, you may not be able to understand the larger picture from looking only at the details. With Excel charts, you can summarize, highlight, or reveal trends in your data that might not be obvious when looking at the raw numbers.
At the vacation resort Adventure Works, the sales manager records expense data and estimates future revenue in the Five Year Sales workbook. He intends to use charts to summarize the annual sales projections and quickly see which business area has the highest percentage of expenses. The activities coordinator tracks the pledges collected from members at resort events, and she uses charts to analyze the trend in pledge rates at various levels over the year.
Download the following documents and save them to your pc  Five Year Sales and Member Pledges
Once they are saved go to the folder containing the documents  and open Five Year Sales with Excel
Create a chart using the Chart Wizard
In this exercise, you open a workbook and create a chart using the Chart Wizard.
Select cells A2:F6 in the Sales Projections worksheet.
On the Standard toolbar, click the Chart Wizard button. The Step 1 Of 4 – Chart Type dialog box appears.
In the Chart Type list, click Column, if necessary.
In the Chart Sub-type box, click the Stacked Column sub-type in the center of the top row, and click Next.  The Step 2 Of 4 – Chart Source Data dialog box appears with a preview of your chart.
On the Data Range tab, verify that the Rows option is selected, and click Next.  The Step 3 Of 4 – Chart Options dialog box appears.
In the Chart Title box, type Yearly Sales, and click Next. The Step 4 Of 4 – Chart Location dialog box appears.
Click the As Object In option, if necessary, and click the Finish button. The chart appears in the worksheet, and the Chart toolbar displays. The data that’s charted is outlined in blue.
Moving, Resizing, and Modifying a chart
In this exercise, you move, resize, delete, and restore a chart.
If necessary, click a blank area of the chart to select it.
Drag the chart to a position below the data and along the left edge of the worksheet
Drag the sizing handle on the right edge of the chart to the right side of column F to make the chart wider.
Drag the bottom sizing handle to the bottom of row 27 to make the chart longer.
Click the Chart Area, and press the Delete key. The chart disappears from the worksheet.
On the Standard toolbar, click the Undo button. The chart reappears on the worksheet.
Save the workbook with the current name.
Modifying Chart Titles and Adding Axis Labels
In this exercise, you change the title of the chart and add labels for the X and Y axes.
Right-click a blank area of the chart, and click Chart Options. The Chart Options dialog box appears with the Titles tab displayed.
In the Chart Title box, select “Yearly Sales,” and type Five-Year Revenue Projection. The new title appears in the chart preview.
In the Category (X) Axis box, type Fiscal Year. The axis title appears in the chart preview.
In the Value (Y) Axis box, type Revenue (in thousands), and click OK. The chart appears with the new title and axis labels.
Right-click the chart title, and click Format Chart Title. The Format Chart Title dialog box appears.
Click the Font tab, if necessary, and on the Size list, click 12. Click OK. The chart title appears smaller.
Save the workbook with the current name
Format the legend and the pieces of a pie chart
In this exercise, you reposition and format the legend and draw out pieces of the pie chart.
Click the Expense History sheet tab. The sheet contains a pie chart.
Drag the chart legend to the lower left corner of the Chart Area.
Right-click the chart legend, and click Format Legend. The Format Legend dialog box appears.
Click the Patterns tab, select the Shadow check box, and click OK. The legend appears with a shadowed border.
Click the pie area, and click the smallest piece of the pie. Sizing handles appear around the piece.
Drag the piece a short distance away from the pie. The piece appears separated from the rest of the pie.
Save and close the Five Year Sales workbook.
Open Member Pledges..
Change the chart type, and organize the data
In this exercise, you change the chart type and organize the source data.

Click the Chart sheet tab. The sheet contains a column chart showing pledges collected in each category.
Right-click the Chart Area, and click Chart Type.
The Chart Type dialog box appears.
On the Chart Type list, click Area.
Click the Stacked Area chart sub-type in the center of the first row.
Click OK in the Chart Type dialog box. A stacked area chart appears.
Right-click the Chart Area, and click Source Data. The Source Data dialog box appears, and the worksheet from where the data was taken opens with a flashing marquee around the range of the source data.
On the Data Range tab, click the Rows option, and click OK. The updated chart appears
Right-click the Chart Area, and click Source Data. The Source Data dialog box appears, and the source data worksheet opens.
On the Data Range tab in the Data Range box, click the Collapse Dialog button.
Select A5:F9, and click the Expand Dialog button in the Source Data –Data Range dialog box.
In the Source Data dialog box, click OK. The chart appears with the data added for the month of December.
Save and close the Member Pledges workbook
Update source data, and format axes
In this exercise, you update the source data for a chart and format the axes.
Open Five Year Sales
Switch to the Sales Projections sheet, and type the following values.
Cell: B4 122 C4 126 D4 141 E4 142 F4 146
Cell: B6 308 C6 312 D6 311 E6 299 F6 303
The chart updates to reflect the new values
Right-click the Value axis, click Format Axis, and click the Scale tab in the Format Axis dialog box. The Format Axis dialog box appears with the Scale tab displayed.
In the Minimum box, type 500.
In the Maximum box, type 2100, and click OK. The chart appears with the updated axis.
Add gridlines and graphic objects to a chart
Sometime you would like to draw attention to the effects of the new marketing campaigns. Adding gridlines will more clearly define the impact of the new revenue levels. An arrow will emphasize the largest change in revenue
In this exercise, you add gridlines to the chart and add and move an arrow. You also add a text box to label the arrow.
Right-click the Chart Area, and click Chart Options. The Chart Options dialog box appears.
Click the Gridlines tab, select the Minor Gridlines check box in the Value (Y) Axis section, and click OK. The chart appears with major and minor horizontal gridlines.
Click the Drawing button on the Standard toolbar. The Drawing toolbar appears.
Click the Arrow button. Click a blank area in the upper right corner of the chart, drag the mouse pointer to the top of the tallest column on the chart, and click away from the chart. An arrow appears on the chart.
Click the arrow to select it, and drag the arrow so that it points to the top of the center column on the chart.
On the Drawing toolbar, click the Text Box button.
Click a blank area of the chart at the tail of the arrow, and drag to draw a rectangular text box.
In the text box, type Largest Projected Increase! The text appears in the text box.
If all of the text is not displayed in the text box, click the text box, and drag its handles until you can see all of the text.
On the Standard toolbar, click the Drawing button. The Drawing toolbar closes.
Save the workbook.
Preview and print a chart
In this exercise, you preview and print charts.
Click a blank area of the Sales Projections worksheet, and click the Print Preview button on the Standard toolbar. The worksheet and embedded chart appear in the Preview window.
Click the Print button on the Preview toolbar. The Print dialog box appears, and the Preview window closes.
Review your print settings, if your were going to print it you would click OK to print the chart., but for now just click cancel
Click a blank area of the chart this time, and then click the Print Preview button. Only the chart appears in the Preview window
Click the Close button. Notice that this time the chart filled the printed page. 
Save and close Five Year Sales.
Email both Five Year Sales and Member Pledges
 

Back to the main page