If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom Colors on Graph
Is there any way to use custom colors with Excel graphs?
The standard choices are limiting, and other Microsoft titles all allow custom colors. Am I missing something here? Thanks, Sarah |
#2
|
|||
|
|||
Custom Colors on Graph
Sarah -
Excel uses a palette of 56 colors, and that's it. You can adjust these 56 to your heart's content, though. Pick Options from the Tools menu, and click on the Colors tab. The bottom two rows are the ones used in default charts (for more series, it keeps moving up a row). One by one, select a color and click on the Modify button, to adjust the color. When you like the colors, keep them in a handy workbook. Excel allows you to copy a palette between workbooks. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Sarah wrote: Is there any way to use custom colors with Excel graphs? The standard choices are limiting, and other Microsoft titles all allow custom colors. Am I missing something here? Thanks, Sarah |
Thread Tools | |
Display Modes | |
|
|