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
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
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
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
I am sure you have created a Pivot Table in your Excel Workbook. However, have you wanted to easily learn how to add a calculated field? It is not too hard, but it is not always intuitive.
Facebook Twitter Pinterest WhatsApp Linkedin Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating 🙂 to be off by one or 2 pixels. Well Excel
A while back, I published an article on how to make an Area Cliff Chart. Now this isn’t a standard chart type. If you use the Standard Excel Area Chart with blank data, Excel will interpolat
Do you want your Excel charts and dashboards to really stand out at your company? Well then you should start using custom colors in all your graphs. It is really simple, but some people do n