Chart Tools -> Format ->Shape Styles -> Shape Fill

Chart Fun: Format the Shape

Microsoft Excel has additional formatting tools on the Format Ribbon. Here's the plan: can you select one data point, or column, and make it stand out from all of the others?

 

1. Try This: Select the Column Chart

Click once on any Column in the Chart.

Every Column should have handles.

 

Select Only One Column

Click one more time on the first Column.

Now, this data point is the only one selected, the only one with handles.

 

2. Format the Shape

Go to Chart Tools-> Format->Shape Styles.

Select: Shape Fill

 

Keep going...

Exam 77-882: Microsoft Excel 2010 Core

6. Presenting Data Visually

6.1. Create charts based on worksheet data: Format the Shape Fill