![]() ![]() Add and format chart elements in a pie chart.Ĭlick the Chart Elements button in the top-right corner of the chart.Ĭlick the Data Labels arrow to open its submenu and choose More Options. )Ĭlick the Series Options button in the Format Data Series task pane.Ĭlick the chart object border to deselect the Atlanta slice.ħ. The pointer on a slice to see its identifying ScreenTip. ![]() Select the All Charts tab and choose Pie in the left pane.ĭouble-click the pie to open its Format Data Series task pane.Ĭlick the Atlanta slice to update the pane to the Format Data Point task pane. Select the pie chart object and click the Change Chart Type button [Chart Tools Point to the bottom right selection handle to display the resize arrow. ![]() Point to the chart object border to display the move pointer.ĭrag the chart object so its top-left corner is at cell A21. ![]() Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, andĬlick the Recommended Charts button. Change the project file name if directed to do so by your instructor, and save it. The file will be renamed automatically to include The Enable Editing button so you can modify it. If the workbook opens in Protected View, click Insert and format sparklines in a worksheet. Of the stores and insert sparklines in the data.įile Needed: BlueLakeSports-03.xlsx (Available from the Start File link.)Ĭompleted Project File Name: -BlueLakeSports-03.xlsxĬreate, size, and position a pie chart object. You also create a line chart to illustrate week-to-week sales for specific departments in one Blue Lake Sports has locations in several major cities and tracks sales by department in each store.įor this project, you create a pie chart that shows each store’s share of golf-related sales for the first ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |