Pattern Fill Effect in Excel 2007 Charting -- Changed or Obsolete?

[gmsullivan]

In excel 2003, when I created a bar chart, I was able to change the fill in
the individual bars from solid to cross hatch or dots, a useful featue when
trying to display temporary, preliminary or revised information.

I recently upgraded to excel 2007 and cannot find this feature. The only
fill option is to add strange textures or even little fishies.

Does this feature still exist. If so where is it?

Thanks

 

[Bob Greenblatt]

In excel 2003, when I created a bar chart, I was able to change the fill in
the individual bars from solid to cross hatch or dots, a useful featue when
trying to display temporary, preliminary or revised information.

I recently upgraded to excel 2007 and cannot find this feature. The only
fill option is to add strange textures or even little fishies.

Does this feature still exist. If so where is it?

Thanks

Are you really talking about Excel 2007? If so, you're in the wrong news
group. This one is for Macintosh. However, if you really mean Excel 2008, it
doesn't look like those patterns are available. However, you can certainly
highlight individual chart data points from the formatting palette. There
are bunches of ways to single out specific data items.

 

[Jim Gordon MVP]

In excel 2003, when I created a bar chart, I was able to change the fill in
the individual bars from solid to cross hatch or dots, a useful featue when
trying to display temporary, preliminary or revised information.

I recently upgraded to excel 2007 and cannot find this feature. The only
fill option is to add strange textures or even little fishies.

Does this feature still exist. If so where is it?

Thanks

Hi,

You should be able to make a macro that controls those properties (wouldn't
be surprised if someone hasn't already done so).

Excel 2008 users would need to make an AppleScript to do the same.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[bartman1]

I answered this earlier - you can create a fill pattern in Illustrator, save it as a *.png, then put the *.png in the Office/Media/Clip Art folder within Microsoft Office 2008.

I'm still experimenting, but have created horizontal and vertical lines in various colors. If you add a white background in Illustrator, the fill is opaque. If you have no background the fill is transparent. To add a white background, make a rectangle with no border and fill of white, the exact same size as the "field" of lines which cover 8 1/2 x 11" of drawing board.