Date Units on the X Axis- Excel I was working on a dashboard in Excel 2016 and I ran into something a bit frustrating. So, I thought I wou...

Cam't afford fancy software for project scheduling? Try using Excel. The image below is the end result we will achieve. In ...

You get to be my guineau pigs. I played around and created some Excel videos about a year ago and put a few on YouTube and then I just never...

Sorry- the link in the earlier post did not work for some reason. This is an article I wrote on Interactive Charts for the Journal of Accoun...

It's been awhile since I have written anything here. If you have been checking, my apologies - you know how the summer goes- between wor...

Stephen Few, author of Information Dashboard Design , offers some great insights on how to be visually intelligent .   No matter where you a...

Everyone is always trying to get as much information as possible onto a page particularly if they are creating a dashboard. This is where th...

Those of you that read my newsletter know that I am in the midst of putting together a seminar on Excel-Based Dashboards . This has been a s...

USE REPT FUNCTION to Create a CHART I have a friend who likes to create quick charts using the REPT() function. - I thought you might be ...

Hyperlinking a Chart The hyperlink has become my preferred method of linking when doing a Powerpoint presentation - particularly if the c...

Paste Linking a Chart into PowerPoint Everyone wants and needs up-to the date information. So what do you do if you are putting together a ...

2 Y axis Charts So, did anyone try the charting the NFL data I showed yesterday? Well, if you did then it probably looks like the chart belo...

The C ombination chart is a popular business tool for a couple of reasons - you can fit a lot of information on one chart and second, it ca...

Since it is getting to be that time of comparing budget to actual and doing forecasting for 2009, I thought I would show you a couple of dif...

Hey- the holidays are starting to close in.... perhaps that explains why all my examples lately have been wine and food. Anyway, below are t...

Common X Axis Problem If your first column contains numbers, such as years, Excel will not recognize that you want this series to be on the ...

Here is a quick tip about a really quick way to create a chart. Select your data and then press F11 . A full size chart will automatically ...

Customized Charts A custom chart type differs from the default chart type as a custom chart will retain formatting as well as chart type. A ...

Gosh..sorry.. I am really getting behind and it is only November.. December is not looking promising. Anyway, I wanted to spend some more ti...

Using Graphics as a Data Series Adding a graphic can be a really nice effect particularly if you are doing a presentation. Of course it can...