+ Reply to Thread
Results 1 to 3 of 3

I cannot control the transparency of the patterns fill in the boxes I make

  1. #1
    Registered User
    Join Date
    03-22-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    12

    I cannot control the transparency of the patterns fill in the boxes I make

    I cannot control the transparency of the patterns fill in the boxes I make in excel. I made a graph with lines and wanted to fill certain portions in patterns and make it 80% transparent to see the underlying trend lines. I can control the transparency with color fill but cannot do with patterns fill. I need to use strictly patterns fill and control its transparency to see the underlying trend lines in the graphs since the press process only allows black and white with no colors. How can I do this?

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,438

    Re: I cannot control the transparency of the patterns fill in the boxes I make

    you cannot set transparency of patterns. but you can control shades of gray as foreground or background color. that could come close to same result

    other alternatives
    1. use picture or bitmap option. you can set transparency of an inserted picture
    (create the background in paint or create another excel object like textbox and then make screenshot of that and save as picture)

    2. Create a textbox with the size of the graph area give that the pattern then place it under the graph and set the graph area to a fill with white and then control the transparency of the graph to the wanted shade

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,126

    Re: I cannot control the transparency of the patterns fill in the boxes I make

    How are you doing the trend line. For me the trend line appear above the columns.

    Or do you mean grid lines?
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 05-16-2019, 10:09 AM
  2. Chart Fill Effect Transparency Disabled
    By cricrazy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-17-2013, 03:33 PM
  3. Replies: 0
    Last Post: 06-07-2012, 11:09 AM
  4. DataLabels: Setting fill transparency in VBA.
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2010, 10:36 AM
  5. modifying fill patterns
    By David Mursch in forum Excel General
    Replies: 5
    Last Post: 06-15-2006, 08:20 AM
  6. Removing patterns but keeping fill colour
    By matpj in forum Excel General
    Replies: 0
    Last Post: 04-19-2006, 07:36 AM
  7. [SOLVED] radar chart - how to acieve transparency in fill effects?
    By Dagmaraka in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-02-2006, 11:50 PM

Tags for this Thread

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