Results 1 to 2 of 2
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Gradient Fills (Excel 2002 SP2)

    I was just reading this tip on John John Walkenbach's site, and what really caught my eye was the fact that gradient fill is the same for all data points. In other words, the yellow gradient is between 5 and 6.5 , red starts at 8, etc. for all data points.
    This is something I'd like to do and I had assumed was impossible.
    So let me expand on how it was done. When drawing the autoshape make sure it is the same size as the largest data point. After pasting the autoshape into the data series, go to the Format Data Series, Fill Effects, Picture and change the option to Stack. This ensures that all data points will use the same gradient scale.

    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Gradient Fills (Excel 2002 SP2)

    Thanks for the tip! (Or is that the tip on the tip?) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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