
How-to Group and Categorize Excel Chart Legend Entries
If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed that it was not clear on my Stacked Column Chart which ser

If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed that it was not clear on my Stacked Column Chart which ser

Several years ago, I created an Excel workbook and I “Protected” a worksheet, but, I forgot the passcode the next day. Try and try, I couldn’t remember the password. Therefore, I could nev

Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons Here are some other submissions: A

Facebook Twitter Pinterest WhatsApp Linkedin Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish what I started with Part 2

Luckily I was able to help this user, but I think that we can even do more. Here was the original request: “Help Please! I’m new to Excel charts and I need to chart these two tables in a ba

This Friday Challenge involves Network Data Usage. You will find over 17,000 data points representing 2 days of network data usage in the linked file. With so many data points, it may be be

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

Today I answer a viewer question. “How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?” Well there are a few tips and tricks to create this t

If you have ever used a Pie Chart in Excel, then you probably ran into this need. The need to hide Pie Chart Legend entries that are blank or have a value of zero (0). From this: To this: In

Learn how to make an awesome Thermometer Goal Chart in Excel that you can use to track sales goals and other goals of your choosing.