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
Here is another response that I received from Don for our recent Friday Challenge: Friday Pipeline Usage Challenge Since we weren’t sure from the client if the pipeline usage had to remain i
In a recent issue of USA Today, the following infographic was posted on the U.S. women’s national soccer team player appearances. I liked it and wondered if I could make a similar chart usin
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance, if you have a gauge range from