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
In Excel, you will frequently have text that is longer than the cell width and you will often use the Wrap Text feature to make it more readable. However, have you ever had a row that stoppe