Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Custom Chart Colors – Permanently

Friday, January 27th, 2006 by | Filed Under: MS Excel, MS Office Help

Custom Chart Colors – Permanently!

Do you find that when you make a chart in MS Excel that you’re constantly clicking into the chart to change the colors of the bars, lines, etc?

How would you like to change the default colors Excel uses for charts, eliminating all that color switching you’re constantly working on?

Sounds like a good plan to me! I’m always changing those colors so if I can set Excel to create the charts my way automatically, I’m all for it.

Colors can be set through the Tools menu, Options choice.

In the Options window, you’re looking for the Color tab.

On this tab, you’ll find three basic areas of colors you can set.

The top area is the Standard color palette offered when you access things like fill color and font color.

Next is a small (1 row) palette used when filling in spaces on a chart.

And finally, you’ll find another small palette that Excel uses when creating the lines and symbols in a line graph.

It’s these last two color palettes that we’re interested in for today’s tip.

To change a color, click on a current color square. Be sure to pick one that you want to get rid of because you’re going to be trading one color for another.

With the color square still selected, click the Modify button.

A complete color palette will open.

On this palette, choose a color you’d like Excel to use on your charts.

If there’s nothing that appeals to you here, then click on the Custom tab.

Here you can slide the selector all over the entire range of possibilities.

Click OK when your selection is complete.

To change another color, choose a different square and repeat the process.

If you change your mind about the color choices you’ve made, you can restore the entire palette to the way it was when you started by clicking the Reset button in the Options window.

Once you’ve created color palettes that suit your needs, click the OK button in the Options window to exit and save.

And that’s all there is to it! Next time you create a chart you’ll find that Excel used your custom color choices from chart creation!

~ April

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive