Like most Excel users, one of the first formulas that you ever learned to master was the Concatenate Function. But how do you add other controls like a Hard Return or a Tab to your Concatena
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
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
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what i
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.
In our recent Friday Challenge, a user asked this: “This is a scatter with smooth line and markers graph. What I would like to have displayed, is everything above the blue line one colour, b