Create a Battery Chart in Excel- HINDI│Company Progress Chart or Dashboard Battery Chart in Excel

Create a Battery Chart in Excel / Create Battery type Chart in Excel

Create a battery chart in Excel just like you see on your smartphone, tablet device or even PC. It is a great visual way of viewing the percentage remaining of a value.

first of all, we need to create a spin button from developer tap. how to create a spin button you can see in the below mentioned linked video.

===================================================
Add Spin Button to a Worksheet│Fake Scroll Button in Excel for Dashboard in HINDI
https://www.youtube.com/watch?v=XQxzdiNiMGE
====================================================
How to Add a Scrollbar in Excel Worksheet│Part-2│Excel Dashboard Trick in HINDI
https://www.youtube.com/watch?v=WfC3yEg3Rac
====================================================

In Excel, a battery chart could be used to view the amount remaining on a budget, the work remaining on a task, or a number of people still to attend training.

There are many reasons why you may want to visualize an amount dropping until it is empty, or complete. A battery chart provides a method that people can relate to easily.

Setting Up the Spreadsheet
The image below shows the data being used for this training budget battery chart. Here are some things about this setup.

Cell A14 contains a SUM function totalling the amount spent from A6:A12.
Cells B2 and E2 both contain 5%. This value will be used to create the top and bottom caps of the battery.
Cell D2 contains the formula A14/C6. This is the total spent/budget. This cell is formatted as a percentage.
Cell C2 contains the formula 1-D2. This finds the remaining percentage.
Creating the Battery Chart
Select the range of cells you want to use for the chart. In this example that is A1:E2.
Click the Insert tab on the Ribbon. Then click Column and select the Stacked Cylinder.
A separate cylinder is used for each column of our data. Click the Switch Row/Column button on the Design tab to correct this.
Remove the 3D rotation by double clicking on the chart area (white space around the outside of the chart), select 3-D Rotation and set the X and Y values to 0.
Next we will remove all the unwanted chart elements. These include the legend, both axis, gridlines and the floor.
Some of these are awkward to select so use the Chart Elements list of the far left of the Layout tab on the Ribbon. Then press Delete on the keyboard.
Formatting the battery chart is next. Double click on each of the four parts of the battery in turn and select Fill, Solid Fill and then a color of your choice from the options provided.
I have opted for dark caps, with a white spent area and a green remaining area similar to what you would find on a smartphone battery.
The final and optional step is to add a chart title. Click the Layout tab on the Ribbon, Chart Title and then Above Chart. Enter a title and press Enter.
Create a battery chart in your own Excel spreadsheets to track progress. They are easy to understand and look awesome.

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
https://www.youtube.com/channel/UC2k9JH38F3byw92XaFuoPuw?sub_confirmation=1
फेसबुक पर पसंद करने के लिए क्लिक करें
https://www.facebook.com/Comtutor4u/
ट्विटर पर फॉलो करने के लिए क्लिक करे
https://twitter.com/Comtutor4u

Видео Create a Battery Chart in Excel- HINDI│Company Progress Chart or Dashboard Battery Chart in Excel канала ComTutor