Quote:
Originally Posted by beetmixer
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.