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
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+)?
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
1 of 1 people found this helpful
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.
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.
Dana, wow. Nicely done! Thx!