On Friday, I posted this challenge: 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 you
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable? Check out this chart to see what I mean: Overlapped Horizontal Categories If you r
Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards or Tilde’s. If you are trying to Find or Find & Replac
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
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