+ Reply to Thread
Results 1 to 9 of 9

Apply transparency to pattern fill in drawing Excel 2010

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Smile Apply transparency to pattern fill in drawing Excel 2010

    Howdy there!

    I've got a line graph with 4 lines on it. I'm trying to do a pattern fill between two of the lines so that i can see where it merges with the pattern fill between the other two lines. I've drawn the two shapes between their respective lines, and when I use solid fill I can change the transparency (so that I can see where they merge), but I want to use pattern fills. Unfortunately I can't see any transparency option with the pattern fill for drawings. Is there a way around this that anyone knows please?

    Thanks very much.

    Cekka

  2. #2
    Forum Contributor
    Join Date
    12-08-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    173

    Re: Apply transparency to pattern fill in drawing Excel 2010

    have u checked the fill options..becaue in shapes ther is trancperancy for , picture, solid and gradiant

  3. #3
    Registered User
    Join Date
    02-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Apply transparency to pattern fill in drawing Excel 2010

    Yep, I checked those and youre right, there are transparency options for picture, solid and gradient, but not for pattern fill :*(

  4. #4
    Forum Contributor
    Join Date
    12-08-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    173

    Re: Apply transparency to pattern fill in drawing Excel 2010

    hmm..i didn't see a parttern..but ill check again..

  5. #5
    Registered User
    Join Date
    02-24-2013
    Location
    New Haven, CT
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Apply transparency to pattern fill in drawing Excel 2010

    I don't believe there is an option to adjust transparency in a pattern fill. However, I was able to solve a similar problem by sending the shape with the pattern fill to the back (so that my other lines / shapes sat in front).

  6. #6
    Registered User
    Join Date
    08-30-2013
    Location
    Glen Burnie, MD (USA)
    MS-Off Ver
    Excel Starter 2010
    Posts
    1

    Thumbs up Re: Apply transparency to pattern fill in drawing Excel 2010

    Quote Originally Posted by Cekka View Post
    Howdy there!

    I've got a line graph with 4 lines on it. I'm trying to do a pattern fill between two of the lines so that i can see where it merges with the pattern fill between the other two lines. I've drawn the two shapes between their respective lines, and when I use solid fill I can change the transparency (so that I can see where they merge), but I want to use pattern fills. Unfortunately I can't see any transparency option with the pattern fill for drawings. Is there a way around this that anyone knows please?

    Thanks very much.

    Cekka
    I had a similar problem where I wanted to make a diagonal line pattern fill shape transparent and notices there was no option for that under the pattern fill menu. My work around to this consisted of me first creating the shape I wanted and filling it with the pattern I desired. Next I copied the shape (good ol Ctrl-c) and then returned to the format shape menu where I then went to fill and now selected picture or texture fill and click the insert file from clipboard. Once you do that, you can then change the transparency and viola! Your now patterned shape is transparent. The only drawback with this is that the whole pattern becomes transparent where I wanted the black lines to stay dark and the alternating white lines show the image behind it, but it works enough for me to get the job done. Hope this helps you in some way, and if there any spelling or grammatical errors, I apologize as I'm typing this on my iphone and I have fat thumbs.

  7. #7
    Registered User
    Join Date
    02-18-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Apply transparency to pattern fill in drawing Excel 2010

    DJ:

    I found your workaround solution, too. However, I want to implement these steps in VBA. The problem is that the Record Macro functionality doesn't pick up these steps with code.

    I've spent most of the day looking for a VBA code solution to this with no luck. If it's out there, I'm afraid it's over my head.

    Any ideas?

    Randy

  8. #8
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Apply transparency to pattern fill in drawing Excel 2010

    randymaddox,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

  9. #9
    Registered User
    Join Date
    05-16-2019
    Location
    Chattanooga, TN
    MS-Off Ver
    365
    Posts
    1

    Re: Apply transparency to pattern fill in drawing Excel 2010

    I figured out a work around. I took a MS Windows Snip of the pattern I wanted to use. Getting as close to one unit of the pattern as possible, then I went to Paint.net and pasted it in. In Paint.net (Free Open Source, (i think) program) I went to "Image" "Canvas size" and changed the canvas to 11 x 11 pixels... this saved the pattern single unit as a ".PNG" file, naming it "Pattern1.png". I then chose, instead of pattern fill, Picture or "texture fill",and selected the Pattern1.png file. The key is to then check the "Tile picture as texture" check box. The transparency slider is right above... it worked perfect... I'm so excited... I've been trying to figure this out for a while.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1