Attach Right Curly Brace To XY Scatter Points

[goss]

Hi all,

Using Excel 2010

I created a stacked area chart such as this at the Washington Post.

I added a second helper chart next to the original chart.
I deleted all series but one, added a new series for min/max values (2000-2011), set the new series chart type as XY Scatter Points, formatted points to my liking and set font color for all axes elements to white.

So far so good.

Now I would like to add a Right Curly Brace so the top of the brace is linked to the max value scatter point and the the bottom of the brace is linked to the min value scatter point.

All attempts to this point have resulted in pasting the curly brace or multiple curly braces at the mid-point of the curly brace to the scatter points.

Any idea(s) on how I might be able to accomplish this?

 

[Jon Peltier]

Unfortunately it is not possible to link the position or size of a drawing object to built-in chart elements. You will have to either manually draw and fit your curly brace, or use some code to align and resize it.

 

[goss]

Thanks Jon,

Do you have a link to some vba I could look at for pointers how to accomplish the objective?

 

[Jon Peltier]

I don't have anything handy that would be useful in this context.

 

[goss]

Thanks Jon,

I appreciate your input.