Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

Category Archives for Charts

How To Create a Tornado Chart In Excel [Step By Step]

    how to create tornado chart in excel using this step by step guide featured image

    Tornado Chart is useful for those who want to analyze their data for better decision making. It’s a useful tool for sensitivity analysis, but you can use it for comparison purpose as well. As tornado chart is not there in excel by default, we have to create it by customizing some other chart (Bar Chart). If you […]

    Check it out now

    How To Add a Vertical Line in Excel Chart [Easiest Method]

      how to add a vertical line in excel chart featured image

      Have you ever tried to add a vertical line in excel chart? If not yet. Then it’s time to give it a try. You can use this vertical line to highlight a specific point in your chart. Here, in this post I’ll share with you the easiest way to add a vertical line in excel chart. […]

      Check it out now

      How To Create a Thermometer Chart In Excel

        featured image how to create thermometer chart in excel

        I love to use thermometer chart in excel. A thermometer chart in excel is one of the best ways to track single point target vs. achievement. And, it’s super easy to create. Here, I have a step by step guide to help you to create your first thermometer chart in excel. After that, I’ll show […]

        Check it out now

        Super Lite Excel Gantt Chart Template For Project Managers

          Excel Gantt Chart Template

          Are you an emerging project manager? If Yes, then here I have a simple but powerful Excel Gantt Chart Template for you. This excel Gantt Chart template is Super Lite. You have to input minimum details about your project for tracking. Please follow this post to learn about the working of this excel Gantt chart […]

          Check it out now

          How To Copy Chart Formatting To Another Excel Chart [Trick]

            copy chart formatting to another excel chart using this charting tip

            Do you know how to Copy Chart Formatting To Another Excel Chart? Let’s say, with your extreme efforts, you have formatted a chart. And, you realize that you have more charts to format. It’s a pain. But, I have a super quick solution to your pain. All you need just a few clicks with your […]

            Check it out now

            How To Create An Excel Pivot Chart In Excel

              excel pivot chart for dynamic chart for date analysis

              Do you remember when last time you used an Excel Pivot Chart? And, do you know pivot chart is a easiest way to create dynamic charts in excel? The bad news is, most of the Excel users avoid using pivot chart in their work. But the good news is, creating a pivot chart is simple, just like a creating a […]

              Check it out now

              How to Create Waffle Chart in Excel for Smart Dashboards

                Excel Waffle Chart In Excel Using Cells Grid And Label For Percentage

                In this post, you will learn how to create a Waffle Chart In Excel and how can you use it in your dashboards. You will also learn about benefits & limitations of it. Excel Waffle Chart is easy to create, looks good and the user can easily understand it. You can use this chart to track […]

                Check it out now

                How To Create a Population Pyramid In Excel [Step By Step]

                  Create Population Pyramid In Excel In Different Ways

                  To analyze population data we can create a Population Pyramid in Excel. Here I have listed 3 different ways to create an Excel Pyramid Chart. All the three methods are simple to use & you can choose anyone which you think is a perfect fit for you.

                  Check it out now

                  How To Make a Pictograph in Excel

                    Make a Pictograph in Excel

                    In this post, I will show you how to make a pictograph in excel using a bar chart. My idea to make a pictograph is to present the number of employees in various age groups in a company. I am just trying to click an idea to use a picture in a chart to make it more […]

                    Check it out now

                    How To Use Dynamic Data Labels To Create Interactive Excel Charts

                      Create Highlight dynamic Data Labels in Excel Charts

                      In this post, I will show you that how to create Dynamic Data Labels which you can Highlight when you need them. The basic idea of creating these Dynamic Data Labels is to Create Interactive Charts which can further help you to create some Interactive Dashboards. How this Dynamic Data Labels In Chart Work You can […]

                      Check it out now