Highlighting One Column in Excel 2007:-

If your chart title is calling out information about a specific data point, you can highlight that point to help focus the reader’s attention on it. While the tools on the Design ribbon don’t allow this, you can easily achieve the effect quickly by using the Format ribbon.



(The column for Friday is highlighted in a contrasting color, and it is also identified in the title.)

To create the chart in the above Figure, you follow these steps:

1. Create a column chart by choosing Column, Clustered Column from the Insert ribbon.

2. Click any of the columns to select the entire series.

3. On the Format ribbon, choose Shape Fill, White. At this point, the columns are invisible. However, in this case, you want to outline the bars.

4. From the Format ribbon, choose Shape Outline, Black. Choose Shape Outline, Weight, 1 point. All your columns are now white, with black outline.

5. Click the Friday column in the chart. The first click on the series selects the whole series. A second click selects just one data point. (If you accidentally click outside the series, you might inadvertently deselect the series.) If all the columns have handles, click Friday again.

6. From the Format ribbon, choose Shape Fill, Black.

7. On the Layout ribbon, turn off the legend and the gridlines.

8. Type a title, as shown in the above Figure, pressing Enter after the first line of the title. On the Home ribbon, change the title font size to 14 point, left-aligned.

9. Right-click the numbers along the vertical axis and choose Format Axis. Change Major Unit to Fixed, 500.