5 Replies Latest reply on Dec 6, 2018 4:31 PM by Don Wise

Without putting in a background image, how can I get shading behind a Scatter Plot where it breaks out in regions on the graph instead of the standard "four quadrants" (my mock-up screenshot below).

Business Case: Based on volumes of an activity and type of work (not represented below - will represent with shapes) there are acceptable times. Due to the variation in different types of work the standard four quadrants don't represent the data very well.

Why this view: When I mocked-up this idea the team thought this would work with what we're trying to do.

No workbook attached - just wondering if this is even possible without using a graphic.

Thanks

• ###### 1. Re: Scatter Plot Background Shading

Hi Dana,

See this thread (and there's another thread imbedded in that thread) which might help point you in the right direction: How to show percentile markers / probability distribution on a bar chart? Thx, Don

• ###### 2. Re: Scatter Plot Background Shading

Hi Don,

Thank you for the quick response.

This uses Reference Bands which, unfortunately, go from end-to-end. I tried using them at first and wasn't able to get the look above.

Is there a way to limit the length of a reference band (i.e. have it start at 30 on the Y-axis and end at 180 on the X-axis instead of going all the way to 220+)?

• ###### 3. Re: Scatter Plot Background Shading

Hi Dana,

I think the approach is likely to be the same where you're referencing (no pun intended ) a calculation to limit the min and max of a band or perhaps using an Index() calc to help get you there.  This thread using INDEX() is about as close as I've found, referencing that concept.  Hope it helps!  Thx, Don  reference band / definition of area

• ###### 4. Re: Scatter Plot Background Shading

While I wasn't able to get the Index() function to work it did help me think about another solution which works great. I know someone will benefit from your solution so I'm marking it as correct.

My solution:

I used Reference Bands with Constants

I started with the bigger square and worked down and made the bands along the columns (in the picture below, Profit) (pic 1)

I then created the "top" of the green box with Row Bands with constants orange along Sales (pic 2)

I then put another blue Band on Profit (to cover the Orange) (pic 3)

I repeated covering the top box of Orange with a Blue Band on Sales (pic 4)

And I finish up by placing a White Band on sales to give the top of the Blue Box and a White Band on Profit to hide the "tails" of the Sales Bands (pic 5)

Hope this helps someone.

1 of 1 people found this helpful
• ###### 5. Re: Scatter Plot Background Shading

Dana, wow. Nicely done! Thx!