 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008Pattern Fill Effect in Excel 2007 Charting -- Changed or Obsolete?
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 On 2/8/08 5:01 PM, in article B88AC638-CA23-41D2-B145-834FCDCA5E75@microsoft.com, "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 [quoted text clipped - 6 lines] > > 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.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Quoting from "gmsullivan" <gmsullivan@discussions.microsoft.com>, in article B88AC638-CA23-41D2-B145-834FCDCA5E75@microsoft.com, on [DATE: > 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 [quoted text clipped - 6 lines] > > 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 SignatureJim Gordon Mac MVP MVPs are not Microsoft Employees MVP info http://mvp.support.microsoft.com/ 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.