Pelican Parts
Parts Catalog Accessories Catalog How To Articles Tech Forums
Call Pelican Parts at 888-280-7799
Shopping Cart Cart | Project List | Order Status | Help



Go Back   Pelican Parts Forums > Miscellaneous and Off Topic Forums > Off Topic Discussions


Reply
 
LinkBack Thread Tools Rate Thread
Author
Thread Post New Thread    Reply
AutoBahned
 
RWebb's Avatar
 
Join Date: Jul 2007
Location: Greater Metropolitan Nimrod, Orygun
Posts: 55,993
Garage
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?

Old 09-23-2013, 07:13 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #1 (permalink)
Max Sluiter
 
Flieger's Avatar
 
Join Date: Mar 2006
Location: So Cal
Posts: 19,644
Garage
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
Old 09-23-2013, 07:26 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #2 (permalink)
Slackerous Maximus
 
HardDrive's Avatar
 
Join Date: Apr 2005
Location: Columbus, OH
Posts: 18,182
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.
Old 09-23-2013, 07:40 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #3 (permalink)
AutoBahned
 
RWebb's Avatar
 
Join Date: Jul 2007
Location: Greater Metropolitan Nimrod, Orygun
Posts: 55,993
Garage
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...
Old 09-23-2013, 07:59 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #4 (permalink)
Just thinking out loud
 
mattdavis11's Avatar
 
Join Date: Nov 2001
Location: Close by
Posts: 6,885
Pivot table.
__________________
83 944
91 FJ80
84 Ram Charger (now gone)
Old 09-23-2013, 08:02 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #5 (permalink)
Targa, Panamera Turbo
 
M.D. Holloway's Avatar
 
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
Old 09-23-2013, 08:11 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #6 (permalink)
 
Just thinking out loud
 
mattdavis11's Avatar
 
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)
Old 09-23-2013, 09:23 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #7 (permalink)
Reply


 


All times are GMT -8. The time now is 08:19 AM.


 
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website -    DMCA Registered Agent Contact Page
 

DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.