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 An In-Cell Gantt Chart With REPT Function

    In Cell CHart With REPT Functions In Cell Gantt Chart

    Creating In-Cell Charts with REPT Function is a smart move. You can use these charts in your dashboards to give a quick view to your user. I have used this text repeating formula to create an In-Cell Column Chart & a Star Rating Template. But, here I have created an In-Cell Gantt Chart for the sake of my laziness. Let me […]

    Check it out now

    How To Create A In Cell Column Chart With REPT Function

      In Cell Charting With REPT Function To Create a Column Chart

      Creating an In Cell Column Chart by using the REPT Function is the second part of our in cell charting Series. Yesterday, I had used this text repetition formula to create a star rating template in excel. Basic Idea of creating a column chart with REPT Function is as simple as we create a normal column chart in excel. I have used a percentage data set to create […]

      Check it out now

      Star Rating Template In Excel Using REPT Function [Quick Tip]

        Excel Star Rating Template In Excel Using REPT Function

        Here is a quick tip for you to create a star rating template in excel. To create this star rating template all you need, REPT Function. REPT Function is useful when you want to repeat a given text for a number of times. And, today we will use this formula to create this Star Rating […]

        Check it out now

        How To Change the Default Chart Type In Excel

          Do you know you can insert a chart with a shortcuts key? You can use Alt + F1 to insert a chart. But here’s a twist. In Excel, default chart type is a two-dimensional column chart. So, if you want to insert a line chart or any other chart which you use frequently with a […]

          Check it out now

          How To Add Secondary Axis In Excel Charts In Simple Steps

            How To Add Secondary Axis In Excel Charts

            Steps For Adding A Secondary Axis In Your Chart Follow these simple steps to create a dual axis. Method 1 Select the data series for which you want to add a secondary axis. Right Click on it & Go to Format Data Series → Series Option → Activate Secondary Axis. Now, you have a two scales in your chart. […]

            Check it out now

            How To Create Gauge Chart In Excel – Why & Why Not

              Create Gauge Chart In Excel

              Excel Chart family has powerful tools to present data (Area Charts, Pie Charts, etc.).  But, sometimes we have to go beyond the power of Excel inbuilt functions. These types of things require some creativity with proper knowledge of excel. Today, we are going to create a Gauge Chart In Excel.   What is Gauge Chart in […]

              Check it out now

              How To Create Cricket Score Chart in Excel

                People out there are just crazy about cricket. I am also a big fan of the game. I love to watch some of my favorite players scoring. Apart from the players who are performing on the ground, we also have some people who are performing outstanding and consistently in the entire game and in all […]

                Check it out now

                How To Create An Area Chart In Excel

                  An area chart can help you to present data in a better way. It’s just like a line chart, but in an area chart, the area below the lines is filled with a color. You can use an area chart to make a visual trend comparison of your data and to present a trend line for a time period. In […]

                  Check it out now