×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Graphs in Excel 2007

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.

RE: Graphs in Excel 2007

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

RE: Graphs in Excel 2007

(OP)
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.

RE: Graphs in Excel 2007

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

RE: Graphs in Excel 2007

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

RE: Graphs in Excel 2007

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

RE: Graphs in Excel 2007

(OP)
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.

RE: Graphs in Excel 2007

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

RE: Graphs in Excel 2007

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources