Wednesday, February 13, 2013

How to Do Multicolor Column Charts in Excel 2010


1. Open the Excel worksheet that contains the data for the column chart.
2. Click and drag to select the categories and data values for the column chart.
3. Click the “Insert” tab on the command ribbon.
4. Click the arrow for the “Column” chart in the “Charts” group.
5. Click the preferred column chart to add a chart representing the selected worksheet data.
6. Click in the chart area to display the Chart Tools ribbon.
7. Click the “Format” tab in the Chart Tools ribbon.
8. Click one column in the plot area. All the columns will appear highlighted.
9. Click the same column once again. This selected column appears outlined.
10. Click the “More” arrow in the “Shape Styles” gallery. A larger gallery of visual styles appears.
11. Mouse over the color samples to preview the effect on the selected column. For example, “Moderate Effect -- Purple, Accent 4.”
12. Click the preferred color sample. The column converts to the selected color. The legend also displays the updated color.

Blogger news