How-To

In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it...

Here is Pete's answer to the recent Music Festival Schedule Challenge. In this video, see how he used Index/Match functions as well as a helper...

Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart we...

We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...

As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...

Add Vertical Line Between Columns in Excel Stacked Column Chart In this tutorial, you will learn how to QUICKLY add a vertical line between columns...

We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have...

In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...

Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...