Home Tags Pivot Table

Tag: Pivot Table

Friday Challenge – My Answer – Chart This Data in Excel

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...
Non-Offset Chart Tip

How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset

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...

Friday Challenge Answer – Find Unique Values from CSV List

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...

Grouping Pivot Table Data in Excel

Advanced Excel Summation Techniques Using Pivot Table

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

Friday Challenge – Advanced Excel Summation Skills

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

SPECIAL - SAVE 10% until July 20th. Use code EDT.




Friday Challenge - Find Unique Class List in Excel ANSWER

Friday Challenge – Find Unique Class List in Excel ANSWER

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...
Final Pivot Table Data Format

How-to Convert an Existing Excel Data Set to a Pivot Table Format

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

How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis

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...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

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

SPECIAL - SAVE 10% until July 20th. Use code EDT.




3 Ways to Add a Target Line to an Excel 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...

Popular Posts

How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
We Know You Better!
Subscribe To Our Newsletter
Be the first to get latest updates and
exclusive content straight to your email inbox.
Yes, I want to receive updates
No Thanks!
close-link
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link