#1
|
|||
|
|||
Show level in cylinder
Hi , I have a basic spreadsheet of a water tank with a cylinder picture in it. I am trying to get the cylinder to show the level which is in cell H4. The level will be a solid blue fill and the remainder lighter color or no color. Anyone know how I can get the level to show in the cyclinder ? |
#2
|
|||
|
|||
Quote:
What you want is an Excel chart, in place of the image. Click on (select) the cells H1 ("Tank Level") and by holding down your CONTROL key, also select H4 (the 5.67% value). Go to the Insert tab on your ribbon and find the chart area. Look for the bar charts graphic, and select a 3D bar (vertical) chart. I used the stacked 3D chart. It'll probably come out looking like a cube. Select that cube shape, and right mouse click and select "Format Data Series." Under the option you can select column shape; change from a box shape to a cylinder. If you click on the paint-bucket symbol, you can adjust to the blue color of your choosing, whether solid or gradient. Then you'll have to decide whether you want to change your scale on the Y axis. It defaulted to ) to 6% for me; you may wish that to be 0 to 100%. To change, click to select the displayed numbers along the gridlines, right mouse click and select Format Axis. In the image I'm attaching, these areas I marked in pink highlighter. You can change the max to 1.0 (or 100%). If you wanted to show the empty part of the "tank" as it it were a clear glass vessel, you'll want to use a stacked chart and calculate the difference between 100% and the % full you are currently at. In H5 I added the simple formula =1-H4. Then I added that as a second series in my stacked 3D chart, changed to no fill and a thin black border. You can see that highlighted green. Obviously I didn't do too much to these as you'll want to finesse the sizing and the labeling yourself. But that should get you started. |
#3
|
||||
|
||||
Try the attached.
Uses cell H4 % value. Bottom of tank doesn't look very good when it's nearly empty. |
#4
|
|||
|
|||
I just saw this tutorial on YouTube, if you want to make it look prettier.
https://www.youtube.com/watch?v=KsyySvsdz0w |
#5
|
|||
|
|||
I just saw this thread and I was going to show you mine but I see you did not even take a few seconds to acknowledge that it worked or not or to say "Thank You" so I won't take anymore of your time.
BTW, mine works exactly as asked. |
#6
|
||||
|
||||
Quote:
|
#7
|
|||
|
|||
@p45cal
You're right. I still cannot get used to the fact that people won't take a few seconds to thank the people that used their time to help. Might be sign of the times for some. BTW, your code is quite a bit shorter and to the point than mine. I like it. |
#8
|
||||
|
||||
It pees me off too; my signature at vbaExpress has been as it is for decades. I used to have the same signature at MrExcel but someone didn't didn't like it and the moderators insisted I remove it, so I did and I haven't contributed there since.
|
#9
|
|||
|
|||
So you had your disagreements with mods also.
I don't feel so lonely now. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2013's Navigation Pane does not show "level 4" headings, even when I click "Show Heading 4" | zrcarlson | Word | 1 | 10-26-2016 09:51 AM |
Automatic numbered lists - Cannot create new point at level 2, after making level 3 points. | icor1031 | Word | 1 | 01-14-2016 09:24 PM |
Navigation pane Show.Heading level x only | NobodysPerfect | Word VBA | 11 | 05-09-2014 05:26 AM |
Heading level numbering in 2010 - wrong after second header level 1 | taran | Word | 3 | 07-08-2013 01:12 PM |
How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |