Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2014
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    XY Scatter with vertical bars in background

    The lecture of http://windowssecrets.com/forums/sho...-Vertical-Band inspired me to insert vertical coloured bars in the background of a Scatter graph. In the mentioned post the trick was to draw lines that looked like bars. The drawback is that they can not be coloured. I wonder if that is possible and how.

    I also read http://peltiertech.com/Excel/Charts/...ticalBand.html but it applies to a bar chart, not a scattered one and I was not able to apply it.

    A very simple chart is attached. Working with Excel 2007, but other versions are fine.
    Background-Vertical-Bars.xlsx

    Anyone can send me any ideas, clues or even better a way to resolve it?

    Thanks in advance
    Juan

  2. #2
    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
    I created the attached using the peltier tip you posted. A stacked bar chart, Some key items:
    Turn the original data into an XY chart after the other groups have been added and put on sec axis
    Use the interval as the range to plot for the stacked bar.

    Steve
    Attached Files Attached Files

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    jcarlosd (2014-10-21)

  4. #3
    2 Star Lounger
    Join Date
    Aug 2014
    Posts
    111
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Try creating the two layers as separate charts, setting them up the way you want. Then set the background and/or other colors in the top one to semi-transparent(it's in the color-picker at the bottom), finally drag the "top" graph right over the top of the "bottom" one. This is a trick that will let you do all sorts of "interesting" charts.

    Regards
    Gordon

  5. #4
    New Lounger
    Join Date
    Oct 2014
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks, sdckapr
    Your solution was simple and it worked. I took some time to reply and thank you, because I was trying to put everything in VBA code, so I can reproduce it with other data and charts.

    Juan

Tags for this Thread

Posting Permissions

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