Excel Unlocked

Venn Diagram in Excel – Usage, Working, Formatting

The Venn diagram is one of the most powerful advanced excel charts. There is no inbuilt chart type for creating a Venn diagram but we… Read Article

Trendlines in Excel – Types and Usage

Trendlines are one of the most useful chart elements in excel. They form a major part of the most important components of excel charts and… Read Article

Custom Error Bars in Excel – Adding and Deleting

In the earlier blog, we learned about the usage and different types of Error Bars in Excel. Custom Error bars are one of a special… Read Article

infographics Interactive Pictograph Chart in Excel

Interactive Pictograph Chart in Excel – Usage, Making

In the earlier blog, we did the usage of a static Pictograph Chart which is nothing but a bar chart with icons used to represent… Read Article

Error Bars in Excel – Types and Examples

Error bars are one of the important Chart Elements in Excel. They are used in many kinds of charts in Excel including Column charts, Bar… Read Article

Stream Chart in Excel – Making, Usage, Formatting

Stream Chart is one of the advanced and powerful charts in Excel. It is a derivative of the existing Stacked Area Chart. The chart is… Read Article

Pictograph Chart in Excel – Usage, Making, Formatting

Pictograph Chart in Excel is a useful chart for visually representing the real-world object count. There is no pre-existing chart type for the Pictograph chart.… Read Article

Waterfall Chart in Excel – Usage, Making, Formatting

Waterfall Chart in Excel is a pre-existing chart also known as Bridge Chart, Flying Bricks Chart, or Mario Chart. This chart is used in many… Read Article

infographics Population Pyramid in Excel

Population Pyramid in Excel – Usage, Making, Formatting

The Population Pyramid is one of the advanced excel charts. It is made up of the pre-existing Bar Chart in Excel. Let us see how… Read Article

Bullet Chart in Excel – Usage, Making, Formatting

Bullet Chart in excel is a derivative of the existing Stacked Column Chart and XY Scatter Chart. Bullet Chart is used to compare the actual… Read Article

Tornado Chart using Conditional Formatting

In the earlier blog, we did the usage and making of a Tornado Chart by using the Stacked Bar Chart in Excel. In this blog,… Read Article

Tornado Chart in Excel – Usage, Making, Formatting

A Tornado Chart in Excel is a derivative of the existing Stacked Bar Chart. Tornado Chart is very useful when we want to compare two… Read Article