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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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,133,652
Messages
5,660,138
Members
418,552
Latest member
Idiocracy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top