|
|
|
|
| Author |
|
|
AutoBahned
|
Drawing Rectangles in Excel
I have some columns of data that I would like to have Excel use to draw rectangles for me. is there an easy way to do this?
Example: Column 1 is car length, with Col2 - width; col3 = car ht. I have these data for several sports cars to compare their size and each row contains the data for a different car (e.g. an RS 550; a Miata; a Bugeye Sprite) I want to get a (sloppy, but quick) visual comparison of relative size by having Excel draw up 2 or 3 rectangles (maybe even overlappiing). any ideas? |
||
09-23-2013, 08:13 PM
|
|
|
Max Sluiter
|
Is it ok for them to overlap at the corner and not share a center? Because then you just make a scatter plot with straight lines and make horizontal and vertical lines.
__________________
1971 911S, 2.7RS spec MFI engine, suspension mods, lightened Suspension by Rebel Racing, Serviced by TLG Auto, Brakes by PMB Performance |
||
|
09-23-2013, 08:26 PM
|
|
|
Slackerous Maximus
Join Date: Apr 2005
Location: Columbus, OH
Posts: 18,206
|
Option C: Get a life.
__________________
2022 Royal Enfield Interceptor. 2012 Harley Davidson Road King 2014 Triumph Bonneville T100. 2014 Cayman S, PDK. Mercedes E350 family truckster. |
||
|
09-23-2013, 08:40 PM
|
|
|
AutoBahned
|
it's raining - no life available
it would be nice if I could put the small rectangle 'inside' and centered on at least 1 axis... |
||
|
09-23-2013, 08:59 PM
|
|
|
Just thinking out loud
Join Date: Nov 2001
Location: Close by
Posts: 6,885
|
Pivot table.
__________________
83 944 91 FJ80 84 Ram Charger (now gone) |
||
|
09-23-2013, 09:02 PM
|
|
|
Targa, Panamera Turbo
Join Date: Aug 2004
Location: Houston TX
Posts: 22,366
|
Spider Graph...
__________________
Michael D. Holloway https://simple.m.wikipedia.org/wiki/Michael_D._Holloway https://5thorderindustry.com/ https://www.amazon.com/s?k=michael+d+holloway&crid=3AWD8RUVY3E2F&sprefix= michael+d+holloway%2Caps%2C136&ref=nb_sb_noss_1 |
||
|
09-23-2013, 09:11 PM
|
|
|
|
Just thinking out loud
Join Date: Nov 2001
Location: Close by
Posts: 6,885
|
I thought we'd start simple.
__________________
83 944 91 FJ80 84 Ram Charger (now gone) |
||
|
09-23-2013, 10:23 PM
|
|
1971 Porsche 911S
