Store card excel graphic

Vanda_a

Well-known Member
Joined
Oct 29, 2012
Messages
938
Hello, anyone know if it is possible for to generate graphic as below picture for storage space?
IMG_7671.jpeg


I am new to dry dock accounting and would like to control empty containers storage. I am nowhere to go, just thinking if it is possible? Or any suggestions for applications for my desire?

Thank you for you advise
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
I searched Google and found below picture. I got an idea. Container A1 is stored at spot A ground floor then the picture show green on spot A and number 1. 1 stand for ground floor. Container B1 is stored at spot B 3rd floor then the picture show green and number 3. Any formula to fill cell or box to green and number base on criteria? Do we use cell or box for this issue? Any other easy way? Thank you very much for your advise
 

Attachments

  • IMG_7672.jpeg
    IMG_7672.jpeg
    132.4 KB · Views: 7
Last edited:
Upvote 0
Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
 
Upvote 0
Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
Just thinking of an other way to solve my problem by adding text box and build as the shelf. Not about formula.
 
Upvote 0

Forum statistics

Threads
1,224,827
Messages
6,181,199
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top