Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2004
    Location
    San Diego, California, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy of Histogram Loses Color (Excel 2003/WinXP SP2)

    I am experiencing the loss of color when copying a histogram chart from Excel 2003. The column bars of the histogram turn gray when I look at the clipboard image of what I copied or use Paste Special with Paste + Picture (either Win Metafile or Enhanced Metafile). The other options for Bitmap or XL Chart Object preserve the original color of the histogram bars, but don't look as sharp when I try to paste into a PowerPoint 2003 slide. I also used (vertical) "Fill Effects" on the bars to give them a 3D look, which seems to be part of the cause, because if I change the histogram to use a "flat" color for the bars, all of the aforementioned options retain the color properly.

    Has anyone else experienced this issue and know any work-arounds?

    Thank you!
    Don Liebman
    San Diego, CA 92115

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Copy of Histogram Loses Color (Excel 2003/WinX

    Does this also happen when you do a paste link?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Nov 2004
    Location
    San Diego, California, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy of Histogram Loses Color (Excel 2003/WinX

    No. Paste Link appears to copy OK, but this will probably make the file size too large, and I don't want to include the data to let anyone convert the file back to XL.
    Don Liebman
    San Diego, CA 92115

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy of Histogram Loses Color (Excel 2003/WinXP SP2)

    Although I do not have this problem myself, it is mentioned several times in the newsgroups. One of the suggested workarounds is to hold down Shift while selecting Edit | Copy. This changes the menu option to Copy Picture. Experiment with the available options to see which ones preserve the fill effect and serve your purpose best.

  5. #5
    Star Lounger
    Join Date
    Nov 2004
    Location
    San Diego, California, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy of Histogram Loses Color (Excel 2003/WinXP SP2)

    Hans,

    That worked (as usual)! The keywords I used to post with didn't come up with anything when I searched earlier.

    Thank you!
    Don Liebman
    San Diego, CA 92115

Posting Permissions

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