Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Chart Format Data Series - Transparency

    Hello all. Working with Office XP, but have had this trouble with other versions of excel. Formatting data series in fill effects, I cannot seem to get the transparency controls to display or work. The from/to scroll bars have no tab, and the numerical percentages are inactivated. The only time I can get the scroll bar to slide (and it jumps right back to the left) is if I select a pattern or a picture. Otherwise when opened, there is nothing to work with.

    I could use the transparencies alot if I could only get it to work!

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Chart Format Data Series - Transparency

    Hi,
    I have never found a way to use this directly. The only workaround I have come across is to do the following: (I'm assuming you have a bar chart, so I will be using a rectangle autoshape)
    1. Insert a rectangle autoshape onto your worksheet.
    2. Double-click the autoshape and, using the Colors and Lines tab, set the colour and transparency you want.
    3. Hold Shift, then select Edit-Copy Picture from the menu. (accept default settings)
    4. Select the data series you want to be transparent.
    5. Choose Edit-Paste from the menu and your data series should now be transparent.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Chart Format Data Series - Transparency

    Rory,
    I have done exactly the same workaround for simple shapes! However, when making charts sometimes this becomes a bit tricky (if using areas).
    Thanks for your quick response, it is greatly appreciated.
    Dale

Posting Permissions

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