Chart Fill how to change

Joe Z

New Member
Joined
Mar 9, 2006
Messages
44
How do I change the choices for the chart fill function in Excel 2007. I would like to use some of the old fill choices (patterns), e.g. cross bars, diagonal bars, etc, that were available in earlier versions of Excel instead of the current choices, marble, etc. Is there an option menu that you use to add the choices?
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

hilyete

Active Member
Joined
Aug 19, 2009
Messages
293
You can add new textures by clicking on the Fill Effects in the "Format Chart Area". Click on the texture tab, then click on "Other Texture..." button. You can use almost any bitmap file as a texture. You'll find some in your Microsoft office >Office>Bitmaps folder. Explore around and you'll find several in other program files. Or you can use a art program like Photoshop to create some of your own. After choosing a file, click "insert" and it will be added to the list of patterns available for your chart.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,492
Messages
5,468,929
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top