Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2022, 12:20 AM
beetmixer beetmixer is offline Show level in cylinder Windows 11 Show level in cylinder Office 2019
Novice
Show level in cylinder
 
Join Date: Jul 2022
Posts: 1
beetmixer is on a distinguished road
Default 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 ?
Attached Files
File Type: xlsx Water Tank.xlsx (11.7 KB, 9 views)
Reply With Quote
  #2  
Old 07-06-2022, 07:14 AM
kilroyscarnival kilroyscarnival is offline Show level in cylinder Windows 10 Show level in cylinder Office 2019
Competent Performer
 
Join Date: May 2019
Posts: 143
kilroyscarnival is on a distinguished road
Default

Quote:
Originally Posted by beetmixer View Post
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 ?
Hi, Beetmixer,

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.
Attached Images
File Type: jpg Screenshot 2022-07-06 100942.jpg (137.7 KB, 29 views)
Attached Files
File Type: xlsx Water Tank -2.xlsx (27.0 KB, 6 views)
Reply With Quote
  #3  
Old 07-06-2022, 07:29 AM
p45cal's Avatar
p45cal p45cal is offline Show level in cylinder Windows 10 Show level in cylinder Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Try the attached.
Uses cell H4 % value.
Bottom of tank doesn't look very good when it's nearly empty.
Attached Files
File Type: xlsm msoffice49305Water Tank.xlsm (18.9 KB, 10 views)
Reply With Quote
  #4  
Old 07-06-2022, 11:32 AM
kilroyscarnival kilroyscarnival is offline Show level in cylinder Windows 10 Show level in cylinder Office 2019
Competent Performer
 
Join Date: May 2019
Posts: 143
kilroyscarnival is on a distinguished road
Default

I just saw this tutorial on YouTube, if you want to make it look prettier.

https://www.youtube.com/watch?v=KsyySvsdz0w
Reply With Quote
  #5  
Old 08-16-2022, 05:22 PM
jolivanes jolivanes is offline Show level in cylinder Windows 10 Show level in cylinder Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default

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.
Reply With Quote
  #6  
Old 08-17-2022, 07:07 AM
p45cal's Avatar
p45cal p45cal is offline Show level in cylinder Windows 10 Show level in cylinder Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Quote:
Originally Posted by jolivanes View Post
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.
Probably because he accepted an answer at cross post: https://www.excelforum.com/excel-gen...-cylinder.html
Reply With Quote
  #7  
Old 08-17-2022, 11:31 AM
jolivanes jolivanes is offline Show level in cylinder Windows 10 Show level in cylinder Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default

@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.
Reply With Quote
  #8  
Old 08-17-2022, 12:18 PM
p45cal's Avatar
p45cal p45cal is offline Show level in cylinder Windows 10 Show level in cylinder Office 2019
Expert
 
Join Date: Apr 2014
Posts: 648
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Quote:
Originally Posted by jolivanes View Post
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.
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.
Reply With Quote
  #9  
Old 08-19-2022, 10:24 PM
jolivanes jolivanes is offline Show level in cylinder Windows 10 Show level in cylinder Office 2013
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default

So you had your disagreements with mods also.
I don't feel so lonely now.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show level in cylinder 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
Show level in cylinder 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
Show level in cylinder 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft