Width of rectangle based on cell value

Question

I am trying to create a day planner where I can position rectangle shapes on a timeline. Each rectangle should represent a job from a job board on a separate sheet. The width of that job should therefore represent the duration of that job and it needs to have a label to help differentiate it from the next job. Can anyone help?

Answer 1

Thank you for your help yesterday I posted my link like you asked. The link is a above

Answer 2

ok all done

the link is

https://onedrive.live.com/redir?resid=AA119E0AD1A944BE%21132

Answer 3

Hi,

Please upload your workbook to onedrive

1. Login to https://onedrive.live.com/
2. Open the public folder.
3. Click Upload in the top.
4. After uploading, right click it and choose share.
5. Click Get a Link.
6. In the option, choose public.
7. Create Link
8. Post the link here.

Remove confidential data

Answer 4

Basically I have 2 different columns that I need to take information from:

• Column D Job title (as I want each shape to be labelled with the appropriate name)
• Column H duration (and this will specify the width of each shape

The job board (sheet 2) will have numerous jobs listed but I do not want to use all of them. I want to be able to quickly pick which jobs I want to represent on the day planner (sheet1) as rectangles and position them manually on the timeline. The timeline is represented in columns which are labelled in 1/2 hour increments. B5 is machine 1, at 7.30am. V5 is machine 1 at 4.30.

Hope this helps

Answer 5

Hi

Have a look to this thread and give more specifications.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/how-to-align-shapes-no-overlap-or-same-distance-in/25eb59e4-488b-4c21-8562-3734ab5a0d39