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:
- 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.
- Right click on any of your chart data points and select format data point
- In the dialog select “fill effects”
- Finally, go to “Picture” tab in fill effects and specify your picture file path.
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
11 Responses
Another way to color the bars or columns in a chart is to draw a rectangle in the sheet (make it larger than the bar it will be used to format). Double click the rectangle to open the Format Autoshape dialog. Format the shape to have no line, and under fill color, choose More Colors, and define the color you want. When done, copy the rectangle, select the series of columns (bars) or the specific column (bar), and use Ctrl+V to paste the shape.
Er… Isn’t it much easier than this? Why don’t you just change the default colour options in Excel? Tools > Options > Color > Modify… And just change the RGB values of the default colours! Isn’t that much better?
This works a treat in Excel 2003. I used the method to fill areas on a pie chart (don’t start..)the chart look perfect, but when I use Copy Picture/as shown when printed an dpaste the pictue into any MS Office document (including the same worksheet just to check) the cours are corrupted, and each segment has quit unwanted graduated shading.
When I paste into Wordpad the colours are fine.
Is this a known issues?
@Meic… Can you try copying the chart (ctrl+c) and pasting special in word / ppt. Use ALT+ES and then select “Enhanced Metafile” or “Bitmap” option to get better clarity of the chart. In the worst case, just do a print screen and paste that in to word and then crop whatever you want.
Thanks much for the great work around, which is perfect for certain types of charts; since you can’t have the border color exactly match the image color, I can’t use this for 3-d pie charts
Hi sir good work for the creative mind
Very creative. Especially if there is a specific color you want and already have an image of.