Excel Tips
Sparklines Are Not Scaled Together »
August 3, 2023
The vertical scale on the sparklines seems to be wrong. This chart is showing that Chicago and Miami have similar January temperatures.
Create Tiny Charts with Sparklines »
August 2, 2023
I need to create a chart for every row in my data set.
When do I Use Which Chart Type? »
August 1, 2023
There are 80 chart types. When should I use which chart type?
Scatter Charts are Versatile But Require a Different Workflow »
July 31, 2023
How to I create a scatter chart with two series?
July 27, 2023
I want the chart column to be green for ratings of 90 or above, yellow for 70 to 90 and red for less than 70. Can I do conditional formatting in a chart?
Two Stacked, One Clustered Column »
July 26, 2023
I need to create two stacked columns clustered with a third column.
Use Rogue Series for Shading »
July 25, 2023
I want to shade the areas between the gridlines in this chart.
Use an Invisible Series to Float Columns »
July 24, 2023
I need my chart columns to float in the air.