Convert Line Chart to Dynamic Step Chart
Excel and Chart legend and MVP Jon Peltier has blogged about how you can convert a line chart into a step chart. I have used the new TRIMRANGE functionality and range names to make a dynamic solution.
(more…)Highlighting a Column in a Chart in Excel
I was reading the book Data Story by Nancy Duarte recently and in it she mentions highlighting a column to draw focus to it. Here’s one way to do that in Excel.
(more…)Excel Data Validation Based on Another Cell
I recently had a question on an old blog post about limiting a cell’s entry to returning a whole number based on a calculated value. The requirement was entering a quantity that was a multiple of a carton quantity.
(more…)TRIMRANGE and Range Names in Excel
The new TRIMRANGE range reference structure can be applied to range names to create flexible and dynamic range names.
(more…)