- #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC HOW TO#
- #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC UPDATE#
- #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC SERIES#
Select Text File (the default) in the left pane (if necessary) and click Gradient Fill. Select More Gradients from the resulting submenu. Click the Font Options dropdown in the Font group. Then, do the following to apply a gradient fill effect to the selected text: The first step is to select the text you're enhancing, as you normally would before applying a format. To be frank, you might never have a need for this option, but it's good to know it's available, for that odd project that needs a bit of flamboyant pizazz. (This option isn't available in Word 2007 or Word 2003.) A gradient fill lets you blend two or more colors instead of just one. #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC HOW TO#
When using this dropdown in Word 2010, you might have noticed the gradient option, but not known how to apply it. In Word 2007, this option's on the Formatting toolbar. Just select the text in question and choose a color from the Font Color dropdown in the Font group (on the Home tab).
Save and close the workbook (Figure 3-70).You probably know that you can change a font's color. Change the page orientation to landscape. Choose Black, Text 1 (second column) for the line color. Select the Markers box in the Show group in the Sparkline Tools Design tab. Click the Format button and set the Column Width to 35. Click the Format button and change the Row Height to 24. Select cells F5:F18 in the Location Range box. Right-click the column F heading and choose Insert. Close the task pane and click outside the chart. #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC SERIES#
Select the Basketball series and apply the same marker changes. Apply the same marker changes for the baseball series. Click the Series Options triangle at the top of the task pane and choose Series “Baseball” (Figure 3-69). Choose Built-in and set the Size to 10. Click Marker and then click Marker Options to expand the group (Figure 3-68).įigure 3-68 Marker options for the data series. Click the Fill & Line button in the Format Data Series task pane. Choose Series “Apparel” to select the line in the chart. Click the Chart Elements drop-down arrow. 
Type Dollar Sales in the Formula bar and press Enter. Click the vertical axis title placeholder. Type Special Promotion Departments in the Formula bar and press Enter. Select the All Charts tab and choose Line with Markers in the Line category. Select Layout 5 to add a data table to the chart sheet (Figure 3-67). Click the Quick Analysis button and choose Charts. Click the Shape Outline button and choose Weight and 1 pt. Click the Shape Outline button and choose Purple, Accent 4, Darker 50% (eighth column). Click the chart object border to select it. If necessary, click Label Options to expand the group. If necessary, click the Label Options button In the Format Data Labels pane. Click the Data Labels arrow to open its submenu and choose More Options. Click the Chart Elements button in the top-right corner of the chart. Add and format chart elements in a pie chart. Click the chart object border to deselect the Atlanta slice. Set the pie explosion percentage at 10%. Click the Series Options button in the Format Data Series task pane. (Rest the pointer on a slice to see its identifying ScreenTip. #PURPLE ACCENT 4 DARKER 50% SHAPE OUTLINE FOR EXCEL MAC UPDATE#
Click the Atlanta slice to update the pane to the Format Data Point task pane. Double-click the pie to open its Format Data Series task pane. Select the All Charts tab and choose Pie in the left pane. Select the pie chart object and click the Change Chart Type button. Point to the bottom right selection handle to display the resize arrow. Drag the chart object so its top-left corner is at cell A21. Point to the chart object border to display the move pointer. Select the Revenue by Department sheet, select cells A4:F4, press Ctrl, and select cells A13:F13. Change the project file name if directed to do so by your instructor, and save it. The file will be renamed automatically to include your name. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. Open the BlueLakeSports-03 start file. Insert and format sparklines in a worksheet. Create, size, and position a pie chart object. 
You also create a line chart to illustrate week-to-week sales for specific departments in one 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 Skills Covered in This Project For this project, you create a pie chart that shows each store’s share of golf-related sales for the first quarter. Finish this excel project please it will the instruction in the word docīlue Lake Sports has locations in several major cities and tracks sales by department in each store.
0 kommentar(er)
