Tag: Chart
Why Does Excel Switch Rows/Columns in My Chart?
Excel can do some crazy things to your Dashboard Templates, Charts and Graphs, but most of the time we just roll with the punches. ...
How-to Make an Excel Area Chart Cliff (Fiscal Cliff Edition)
So all the US news agencies keep talking about the Fiscal Cliff. This reminded me of a problem that many people have when making...
Merry Christmas from Excel Dashboard Templates
Hope you and your family and friends have a wonderful Christmas season.
For the season, I have created a Christmas Wreath made from an Excel...
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Budget Analysts – How would you answer this Excel Chart question?
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive...
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
Customizing the Standard Excel Chart Titles
Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
The Absolute Quickest Ways to Make a New Chart in an Excel Spreadsheet
When creating my Microsoft Excel Dashboard Templates, I frequently create a chart to see how it would look and I don’t always keep them. ...