Results 1 to 11 of 11
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Graphic behind cell data

    I do NOT want a background tiled all over the spreadsheet, but DO want an image to be in a sheet but have the cell data "show through."
    I read repeatedly that this cannot be done in Excel. By 2010 is that STILL the case? If so, GROAN. Any work-arounds?

    To solve the problem, I ended up cutting up my graphic.
    Last edited by kweaver; 2014-09-30 at 15:30.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Are you looking for something like this?


    transparent.png

  3. #3
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    right click lower right of shape until menu
    select format shape>select fill>transparency.
    Attached Files Attached Files

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Yes, Maud...but I don't want to put it as a "background" and have it tile itself 4 times.
    Was this just one image? That's what I'm looking for but don't see how to make it behind the cells like you would do in Word. It also needs to print!!

    dguillett ... it's a graphic (jpg file) not a shape.
    Last edited by kweaver; 2014-09-30 at 18:16.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    I've tried inserting a rectangle in the entire print area and then replace the background in the rectangle and make it fairly transparent, but I end up with the entire graphic transparent which isn't what I want.

    I'm inserting a graphic of a certificate (just the borders) and want to be able to use cell references, calculations, etc. to show through the graphic but keep the brightness of the graphic borders.

  6. #6
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You may not be able to get "egg in your beer" about partial transparency but you can still have borders. Bring up the picture toolbar and play. See attached. How about you attach yours.......
    Attached Files Attached Files

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    This needs a specific graphic of a certificate.

  8. #8
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You really need to know that we do not read minds. So, fully explain what you need with a file and examples along with your excel version.

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Maud, was that a "background" or did you do some other magic? Was the image tiled or was this just one image?
    Does your image also print with the spreadsheet?

  10. #10
    2 Star Lounger
    Join Date
    Aug 2014
    Posts
    111
    Thanks
    0
    Thanked 2 Times in 2 Posts
    kweaver,

    Insert the image as usual, then go to the Picture Tools/Format ribbon. In the Adjust section, click the Color dropdown and select "Set Transparent Color". Then click on a white section of your image.

    This should make all white pixels transparent so you can see the cells underneath and the other colours will display "full strength". If you want to get rid of the cell borders, go to the PAGE LAYOUT tab and in the Sheet Options section untick Gridlines/Print.

    Regards
    Gordon

  11. The Following User Says Thank You to dogknees For This Useful Post:

    kweaver (2014-10-02)

  12. #11
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Thanks, Gordon. That is almost ideal. How did I miss that transparent option in 2010? Hmmm.

    It messed with the outline of the certificate, but I think I can adjust sufficiently to make the client happy.

    Thanks.

Posting Permissions

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