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?


Conditional Format a Chart »

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.


Excel 2016 Adds a Waterfall Chart »

July 21, 2023

I need to create a waterfall chart.