LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Excel 2007 texture fill of chart data series columns



"Andy Pope" wrote:

Hi,

To do individual columns you would first need to select a individual column.
Click a column once to select the column series. Then click the column again
to select the individual column.

Now when you use the addin only the single column should have the pattern
chosen.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"john9210" wrote in message
...


"Andy Pope" wrote:

Hi,

The UI for that feature was removed in xl2007 but this addin provides a
method of doing pattern fills.
http://www.andypope.info/charts/patternfills.htm

And this is how you install add-ins.
http://www.andypope.info/tips/tip010.htm
http://peltiertech.com/WordPress/200...in-excel-2007/

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Leland" wrote in message
...
I need a way to use fill type to distinguish columns in a column chart
for
a
black and white publication. Ideally, this would be the traditional
horizontal, vertical or diagonal stripes or dots or checks. The only
fill
options I seem to get in 2007 Excel are shading, colors, or "textures",
none
of which really fulfill my needs. Is there any way to access the
traditional
stripes or dots from previous versions of Excel?


Andy,
I loaded the add-in ok, but I can't figure out how to apply fill to
individual columns. I'm using black and white, not color and I need the
fill
to distinguish the columns.

Thank,

John9210


Nope, still doesn't work. The addin only appears in the layout and format tabs. When I select a column, only choices on adin are foreground and background. Neither has an effect. I am using Vista and Excel 2007.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Dynamic names for chart series jcollot Charts and Charting in Excel 2 December 13th 07 08:12 PM
fill series by weekdays in XL 2007 Lisa Hetherington Excel Discussion (Misc queries) 1 November 9th 07 05:54 AM
Change chart type in single data series, Excel 2007 momof3 Charts and Charting in Excel 3 June 30th 07 02:45 PM
include more than 3 data series as columns in combination chart Cindy Charts and Charting in Excel 1 June 26th 07 06:52 PM
Excel 2007 fill a series using keyboard commands EchoPapa42 Excel Discussion (Misc queries) 2 March 14th 07 03:55 AM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"