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

      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 Use Watch Window In Excel To Track Cells [Ultimate Guide]

              Delete A Cell In Watch Window In Excel

              Do you want someone to track important cells in your dashboards & data models So that you can easily trace errors & fix them quickly? If you yes, then we have a Watch Window In Excel to help you on that. I had first used this tool in Excel 2010 version & I was amazed at […]

              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 Select Non-Adjacent Cells In Excel

                  select non continues cells in excel

                  I can bet, you never heard that you can select non-adjacent cells in excel without using a mouse. To select the non-adjacent cells most of the times you use CTRL + Click. But, now it’s time to change that way. In this post, I will show you how to select non-adjacent cells in excel without using […]

                  Check it out now

                  Insert Your Frequently Used Excel Formulas With A Single Click

                    Frequently Used Excel Functions

                    This is very obvious that everyone who is using excel have some favorite excel functions or some functions which he or she used very frequently in their spreadsheets. Now, excel has blessed us with a very useful option to get these functions into the cell without typing them. In this tutorial, you will learn to create […]

                    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