Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
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 can you do this same type of Pivot Chart but
Many users have mixed reactions about this secondary axis overlap fix. You can see the post here: Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis Some t
I have posted several Excel chart samples related to Clustered Stacked Column Charts. In case you missed them, you can check them out here: Excel Clustered Stacked Column Chart Tutorials Rec
Facebook Twitter Pinterest WhatsApp Linkedin Here is Pete’s answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper r
In our last Friday Challenge, we wanted to see if you can make a Music Festival Schedule in an Excel Chart. There were 2 questions. 1) Make a chart using Conditional Formatting and 2) Make
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges. This is a similar problem that I ran into at a recent company. Th
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on a chart”. Here is the basis of the question at hand: “I’m not su
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out the challenge here: Original Challenge: friday-chal