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

Create a Step Chart in Excel

    how to create a step chart in excel

    A step chart is perfect to use when you want to show the changes happened on irregular intervals. It can help you to present the trend as well as the actual time of a change. In real, a step chart is an extended version of a line chart. Unlike line chart, it doesn’t connect data […]

    Check it out now

    How To Create a Sales Chart Template In Excel

      how create a sales funnel template in excel

      In this real world, everything has a process. From Marketing to Production, Sales To Purchase everything has a stage. To make the process successful we need to track each and every stage. And, to track a sales process, sales funnel chart is one the best tool you can use. Just think this way. You are a […]

      Check it out now

      How To Create a Milestone Chart in Excel

        how to create a milestone chart in excel

        Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy. And, a milestone chart is a perfect way to track a project in a simple way. The basic idea in milestone chart is to track each step of your project on a […]

        Check it out now

        Add a Horizontal Line in a Chart

          featured image to add horizontal line in excel chart

          You can add a horizontal line in an Excel chart to use as a target line. All you need, 30 seconds to add a horizontal line to an excel chart. And, without much efforts. You know what, my company’s CEO told me these things a year back. It is better to have a comparison to […]

          Check it out now

          How To Create Interactive Charts In Excel

            how to create an interactive chart in excel featured image

            A chart is a perfect tool to present data in an understandable way. But sometimes it sucks because we overload it with data. I believe that when it comes to charting it should be neat & clean. The best solution to this problem is using interactive charts in excel. By using interactive charts in excel […]

            Check it out now

            How To Create a Dynamic Chart Range in Excel

              how to create a dynamic chart range in excel featured image

              I have a strong reason for you to use a dynamic chart range. It happens sometimes that you create a chart and at the time when you update it, you have to change its range manually. Even when you delete some data, you have to change its range. Maybe it looks like that changing a chart range […]

              Check it out now

              How To Create In Cell Bar Chart With REPT Function

                how to create an bar chart with rept function featured image

                In-cell charts are awesome. And today, I’ll show you how to create an in-cell bar chart with rept function. But, do they really worth your time? Yes. Here is the single important reason. They are easy to create and simple to use. Ahead, in this post, I’ll show a step by step process to create a […]

                Check it out now

                How To Create Dynamic Chart Title In Excel

                  Dynamic Chart Title In Excel

                  Dynamic charts are awesome. But, do you know what is the most important part of a dynamic chart? “Dynamic Chart Title”. Yes, dynamic chart title. Creating dynamic chart title in excel is one of the best ways to make your charts interactive. It will help you to show what actually your chart is about. Ahead in […]

                  Check it out now

                  How To Quickly Create a Bullet Chart In Excel

                    how to create a bullet chart in excel step by step guide featured image

                    If you are struggling while selecting a chart for a single data point, you can use a bullet chart. Or, if you don’t like using gauge chart, you can replace it will a bullet chart. So today, I’ll show you a step by step process to create a bullet chart in excel. Along with that, I’ll […]

                    Check it out now

                    10 Excel Charting Tips You Are Still Not Using

                      10 charting tips in excel you are not using featured image

                      The moment you are reading this post you still have to explore a lot of things about excel charts unless you are “Jon Peltier“. Here in this post, I’ll show you 10 charting tips which you can instantly use while creating your next chart. I’m pretty sure that these charting tips will help you to […]

                      Check it out now