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
Check out this post to LEARN 3 Different Ways That you Can Add a Target Line / Goal Line to Microsoft Excel Pivot Chart for you Executive Dashboard.
A newer Excel Chart creator had this question: “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, betwe
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
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help: “Please advise if it is possible to combine a pivot line graph a
We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have fun than with some pranks. And better yet, Excel Pranks. I saw a great thread