Friday Challenge – Stumped on How to Display Data in an Excel Chart
I had some great responses to the last Friday Challenge, so I didn't want to stop the momentum with my answer to the last...
Calculating Hours Difference of Time in Excel Spreadsheets
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you...
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request:
Hi Steve,
I am trying to make a hypnogram with data that we collected over the course...
How-To Create an Excel Step Chart Formula Using the Small Function
In our last Friday Challenge, we were investigating Step Charts. In case you missed it, you can check it out and download the sample...
Terrible Chart Tuesday – Leader Lines
So in yesterday's post, I showed you that in Excel 2013, you can now add leader lines to your Line Chart. They are not...
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...
How-to Add Specific RGB or HSL Colors in Your Company Chart or Dashboard
Do you want your Excel charts and dashboards to really stand out at your company?
Well then you should start using custom colors in all...
Excel Christmas Gift from Poland
Hi All,
I just got a wonderful Christmas gift from our friend Piotr in Poland.
He emailed me his awesome rendering of a Christmas tree in...
How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...