How do I add shapes to an excel graph and have the shape keep its position and ratio on the graph if I have to re-size the graph?? I've used the "Insert" shapes function to draw the rectangle, but it wont stay on the graph or keep its position/ratio to the points on the graph... The picture in the attachment is what I would want to get it to look like even if I re-size the graph...
Thank you!!
Hi
One, (and no doubt quite complex) way would be to write some VBA code that identified each time the graph changes where the points are and altered the Left/Top properties of the rectangles accordingly
The better way, (and no doubt a bit of lateral thinking will identify the best approach) would be to add additional series, and perhaps use high/low bars or other inbuilt chart elements so that the 'rectangles' are in fact just another series of plots, but which are directly related to the original series'.
Maybe you'll be in luck and Andy Pope will be along soon assuming he picks this up.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You will likely need VBA to alter the ratio when the chart changes size.
In the attached, I've changed the "Marker Options" to image and inserted a rectangle. This might help get you started.
Here's a stacked column chart with the top and bottom portions transparent.
The rectangle ratios will adjust with chart sizing.
As Richard mentioned additional series drawing the lines is probably the best approach
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks