Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Category Archives for Charts

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

Let’s say, with your extreme efforts you have formatted a chart and then you realize that you have more charts to format.Applying the same formatting to all the charts is a tedious task, the same thing again and again.It’s a pain.The good news is: there is a super quick solution to your pain. All you […]

➲ Continue Reading

Excel Pivot Chart

Pivot tables are close to my heart. I love to use them. But apart from this, there is one thing which I love to use.That’s ==> Pivot ChartYes, a pivot chart.And, do you know a pivot chart is the easiest way to create a dynamic chart.Today, in this post, I’d like to share with you […]

➲ Continue Reading

Create Waffle Chart in Excel

If you one of those people who hate to use a pie chart in Excel then there is an alternate for you.Waffle ChartA set of grids (squares of equal area) which represents the entire chart. It is also called a square pie chart.In the below example, we have a dynamic waffle chart which you can […]

➲ Continue Reading

Excel Population Pyramid Chart

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.

➲ Continue Reading

How To 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 […]

➲ Continue Reading