how to get more colors in excel charts, beating excel chart color limitation - how to
Here is a simple to trick to beat the 56 color limitation in excel when you are designing a chart: use picture files (jpg, gif, png etc.) to fill the chart area.

You will no longer have to worry about limiting your project report / website / annual report etc. colors to the 56 that excel has.

1 + 3 steps to get more colors in excel charts:

  1. First create a 1*1 pixel sized image of the color you want to use in excel. You can use any software like MS Paintbrush to do this, all you need is the hex code or rgb of the color you want. Visit colour lovers if you are looking for cool color ideas.
  2. Right click on any of your chart data points and select format data point
    excel tip to get more colors in a chart
  3. In the dialog select “fill effects”
    how do I get more colors in microsoft excel spreadsheet?
  4. Finally, go to “Picture” tab in fill effects and specify your picture file path.
    how to enable more than 56 colors in ms excel
    OK your changes. Thats all, now your charts have any color your want.

Also: Download 73 beautiful excel chart templates | Art of excel charting | Become a conditional formatting pro

Do you like this post? Consider subscribing to my newsletter, every weekday I will send you one email with hot excel tips, technology tidbits or business insights that can make you more productive. Each mail will have unsubscribe link so you can stop receiving the mails at any time you wish.

Share some love, add this to StumbleSubscribe to PHD feed Get my Feed, its yummy