Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Color chart background (Excel 2003)

    Subject edited by HansV to be slightly less general than "Excel"

    Can excel be forced to display a multi-colored plot area as depicted in the attached? The old faded color, graphics box routine sort of does the job, but it would be nice if one could define specific areas and select colors accordingly.
    Attached Files Attached Files

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

    Re: Color chart background (Excel 2003)

    You could combine a scatter chart and a stacked column chart using its own axes. See the attached example.
    (I didn't understand the relationship between the colored cells and the colored rectangles on the chart, so I just reconstructed the chart colors. You can modify the source data for the stacked column chart to suit your needs)
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Color chart background (Excel 2003)

    As always ....... thank you ...... in fact, I have use this method in the past, and appreciate the reminder. A drawback on this method ........ since bars are used to simulate a background grid line get buried .... so I am back to hand drawn objects. Any ideas??

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

    Re: Color chart background (Excel 2003)

    I'd probably decide to live without the grid lines...

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Color chart background (Excel 2003)

    How about using the XY scatter to simulate gridlines like in the attached? I hardcoded the spacing and the extremes but formulas could could be used if they will be changed frequently...

    Steve
    Attached Files Attached Files

  6. #6
    Lounger
    Join Date
    Jun 2007
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Color chart background (Excel 2003)

    Almost makes a person begin to truly believe that anything is possible ........ thank you

Posting Permissions

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