Excel Tips and Tricks

How to create a Waterfall Chart in Excel

How to create a Waterfall Chart in Excel

A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...

How to cut and paste transpose in Excel

How to cut and paste transpose in Excel

A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...

How to create a pizza chart in Excel

How to create a pizza chart in Excel

Of course, there isn’t a chart type called a pizza chart in Excel. On the other hand, Excel has a support for inserting images into chart elements. With help of this cool feature, you can give your charts a fancy look. In this article, we are going to show you how to...