Skip to main content

Posts

Showing posts from March, 2020

New Article

How to SUM by matching partial text in Excel

How to create an Interactive Battery Chart in Excel 2016

To create a Battery Chart in Excel means just like you see the charging percentage on your Phone. You can easily identify when you should plug for recharge your phone. Similarly in Sales, we can apply a Battery Chart so that, Team Leader can drive for Sales in time. In this tutorial I will tell you how you can create a Battery Chart in Excel.  Image 1: Interactive Battery Chart in Excel Although I've already written an article in my blog about "Battery Chart", but this is going to be different. I will say this is an Interactive Battery Chart and it will be easy. So, lets start. Here is the Step by Step Tutorial: Step 1: Your first step is making a data table like below image: Image 2: Data table in Excel of Interactive Battery Chart Step 2 : Select F3:I6 data range and Insert a 3D Stacked Column Chart. Image 3 : 3D Stacked Column Chart Step 3 : Click on "Switch Row to Column" button from Design Tab. Step 4 : N