Scaled Rectangles in Chart

[pliskers]

Is there a type of chart that can create a series of rectangles, each of which has its length (along the x-axis) directed by one value in a set, and its height (along the y-axis) directed by a second? In other words, each would be a proportional rectangle with its dimensions in both directions determined by the source data.

I'm stumped - maybe because it can't be done?

 

[pgc01]

Hi Jeff

I don't think you can do it directly with one of the native chart types. I think you must use vba to draw the rectangles yourself. Besides the Width and Height you also need the Left and Top positions. Just add the shapes to the chart. If you need help with the code, post back with details (excel version, data sample, etc.).

 

[Andy Pope]

As long as the rectangle does not require a fill then you can use xy-scatter.

You will need to derive, via formula, 5 sets of x & y values from a Left, Top, Height and Width set of values.

 

[pliskers]

Sounds like it might work, Andy. Can you post a sample, please?

 

[Andy Pope]

check out this example
http://www.andypope.info/charts/RatioAspect.htm

it's for squares and uses a input of X & Y center point and a width. But you should get the idea of 5 data points to draw a rectangle.

 

[pgc01]

As long as the rectangle does not require a fill then you can use xy-scatter.

You will need to derive, via formula, 5 sets of x & y values from a Left, Top, Height and Width set of values.

Thank you for jumping in, Andy.

I was thinking of real rectangles that you could fill and add and format text and did not think of the simpler case.

 

[pliskers]

Thanks all for your help. I think I've got what I need now.