Wednesday, February 13, 2013

How to Change the Color Scheme in an Excel Chart


Change Chart Colors in Excel 2007
1. Open the spreadsheet containing the chart you want to edit.
2. Single-click the chart once to select it.
3. Single-click the individual piece of the chart you want to change to select the piece.
4. Right-click the selected piece and choose the 'Format Data Point' option.
5. Click 'Fill' in the left-hand menu, and then choose the fill option that meets your design needs. Select your desired color, gradient, picture or texture and the selected chart shape is updated immediately. Click 'Close' to close the Format Data point window.
Change Chart Colors in Excel 2003 and earlier
6. Open the spreadsheet containing the chart you want to edit.
7. Single-click the chart once to select it.
8. Single-click the individual piece of the chart you want to change to select the piece.
9. Right-click the selected piece and choose the 'Format Data Point' option.
10. Click the 'Patterns' tab. Choose the fill option that meets your design needs by selecting your desired color, or by clicking the 'Fill Effects' button to view additional options. Click 'OK' to confirm your change and close the Format Data Point menu.

Blogger news