Graphs in Excel 2007
Graphs in Excel 2007
(OP)
Recently switched to version 2007 of excel, quit a difference.
I'm having a problem with graphs. I need to create a serries of black and white graphs with patterns for the different bars and pie piecies. However, the only patterns I can find are textures like wood grains. Has anyone cracked this one?
Thanks.
I'm having a problem with graphs. I need to create a serries of black and white graphs with patterns for the different bars and pie piecies. However, the only patterns I can find are textures like wood grains. Has anyone cracked this one?
Thanks.





RE: Graphs in Excel 2007
-- MechEng2005
RE: Graphs in Excel 2007
RE: Graphs in Excel 2007
You have to read carefully what MechEng2005 told you to do.
Just go back and go over it a few more times ...
Thanks,
G. Feric, PE
http://engware.i-dentity.com
RE: Graphs in Excel 2007
GeoPaveTraffic maybe you might want to label your pieces numericall and then have them ontop of your pie pieces and then make another legend.
ck1999
RE: Graphs in Excel 2007
Sub FixAllPies()
Dim pie As ChartObject
Set pie = ActiveSheet.ChartObjects("Chart 1")
With pie.Chart.SeriesCollection(1)
.Points(1).Format.Fill.Patterned msoPatternLightHorizontal
.Points(1).Format.Fill.Patterned msoPatternLightHorizontal
.Points(2).Format.Fill.Patterned msoPatternLightUpwardDiagonal
.Points(3).Format.Fill.Patterned msoPatternLightDownwardDiagonal
End With
End Sub
you have to set a pattern for each point in your chart
ck1999
RE: Graphs in Excel 2007
Feric and MechEng2005, what you gave works great in older versions of excel; but there is no longer a patterns tab in the fill effects section.
RE: Graphs in Excel 2007
You are right.
In MS Excel 2007, you just cannot do it anymore.
However, in MS PowerPoint 2007 you can do it the old fashioned way -- the requested options are there.
My suggestion is to move your data set to MS PowerPoint and do it there. One can create jpg and/or gif files as well as PDF files from the slides.
Thanks,
G. Feric, PE
http://engware.i-dentity.com
RE: Graphs in Excel 2007
http:/
Look at the past fron Andy Pope as well as the link in the opening article.
HTH
Doug
Doug Jenkins
Interactive Design Services
www.interactiveds.com.au
RE: Graphs in Excel 2007
Also, a star for IDS. Good link, I'm going to install the code from Andy so I don't have to deal with this in the future.
Feric, nice idea and should have worked. Thanks for the thought.
RE: Graphs in Excel 2007
http://virtualpipeline.spaces.msn.com