Graphs in Excel 2007 1

[GeoPaveTraffic]

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.

 

[MechEng2005]

Should be able to right-click the bar or pie section in the graph, select "Format Data Series", and on "Patterns" tab, under area, select "Fill Effects". The you can select the "Patterns" tab.

-- MechEng2005

 

[GeoPaveTraffic]

Yep, that is where it used to be. But now you can only pick patterns like wood, marble, fosil fish and the like. Just doesn't seem to be a way to do a crosshatch or slash pattern.

 

[Feric]

Hi there:

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

 

[ck1999]

To clarify this is excel 2007. Thanks to Microsoft for all the changes jk . I tried a pie chart and you no longer have the options you did with previous editions of excel.

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

 

[ck1999]

See if this helps it uses vba and make more work but hopefully it will help you

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

 

[GeoPaveTraffic]

Thanks ck1999, I'll give that a try this weekend.

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.

 

[Feric]

GeoPaveTraffic:

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

 

[IDS]

GeoPave - I think you'll find what your looking for here:

http://www.dailydoseofexcel.com/archives/2007/11/17/chart-pattern-fills-in-excel-2007/

Look at the past fron Andy Pope as well as the link in the opening article.

HTH

Doug

Doug Jenkins
Interactive Design Services

http://www.interactiveds.com.au

 

[GeoPaveTraffic]

First of all thanks to ck1999, with a few modifications I got the VBA code to work on the charts updated over the weekend. Still don't get why Microsoft would remove something like that from the general version of Excel.

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.

 

[BigInch]

Has MS outlived their usefulness? Fortunately things like OpenOffice are sprouting.

http://virtualpipeline.spaces.msn.com