Tag: Pivot Table

Challenge – Chart This Data in Excel - My Answer A few Fridays ago, I posted this challenge: Link here: friday-challenge-chart-this-data-in-excel Where I asked you to send...

Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...

Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show...

There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...

  This is a fun skills challenge to make sure you are well rounded.  What is the SUM of your Excel Game?  You will find...

On Friday, I posted this challenge: https://www.exceldashboardtemplates.com/friday-challenge-find-unique-list-in-excel/ You can download the sample data set here:  Challenge Sample Data Check out the post and download / try it yourself before you...

In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...

In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question - How...

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

Add a Target Line to an Excel Pivot Chart Many Excel users use Pivot Tables and they find it very easy to create a Pivot...