+ Reply to Thread
Results 1 to 2 of 2

Can I create a line drawing using cell values?

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    Woodstock, ON
    MS-Off Ver
    365
    Posts
    15

    Question Can I create a line drawing using cell values?

    I have an estimating spreadsheet that has various sizes and dimensions of lumber on it.
    I would like to know if anyone has a way that I can create a grid on a new tab with a "1x1" grid and with a fixed start cell, be able to make lines appear on the new tab that represent the lumber sizes.

    for instance
    panel.jpg

    the image above is a fixed grouping of lines and the numbers are populated by the estimate template.
    Problem is if I need a tall panel or a square panel it will never be to scale. I m hoping there is a way to automate the process so I can have scale drawings.

    Any ideas?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,275

    Re: Can I create a line drawing using cell values?

    Hi BVT,

    There might be an add-on product that does what you want. I don't know how to do it using normal Excel. See:
    http://dwtech.ca/wp-content/uploads/...O-Controls.pdf
    https://www.internet4classrooms.com/...ar_drawing.htm

    or

    http://lessonplanspage.com/creating-...lans-in-excel/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-13-2018, 02:12 PM
  2. Drawing a line on a sheet based off cell value
    By LeapingLizard in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-19-2016, 04:03 PM
  3. [SOLVED] Create a Template drawing Values from Main Sheet
    By Ravana in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2015, 01:10 PM
  4. Drawing a line on all column
    By bbke in forum Excel General
    Replies: 1
    Last Post: 04-07-2015, 12:40 PM
  5. Replies: 0
    Last Post: 06-24-2014, 05:51 PM
  6. Line Drawing gives Doulble Line
    By Hercules1946 in forum Excel General
    Replies: 3
    Last Post: 11-04-2012, 08:15 AM
  7. [SOLVED] Drawing a line in bar chart
    By Julien in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-06-2006, 06:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1