Stacked area charts connect points of data over several data points, however if you have blank data or zeros, you need to know how you can add clean breaks or cliff edges to an Excel Area Ch
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
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
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out the challenge here: Original Challenge: friday-chal
How to use a pick list to change the chart type for your excel dashboard graph