Excel Tips


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.


Tie the Chart Title to a Cell »

July 20, 2023

I want the chart title to be calculated on the fly.


Interactive Chart to Show One Customer »

July 19, 2023

We have a monthly meeting to review accounts. They want one chart per customer that we can review at the meeting.