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...
Budget Analyst Question: My Answer
Last week I posted this:
Budget Analysts might be asked by their executive team, managers or co-workers.
Question Title: Bar Graph Below the Line
I need a...
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 Create a New York Times Tiger Woods Chart in Excel
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times. Here is the chart...
How-to Make a Wall Street Journal Horizontal Panel Chart in Excel
In a recent Wall Street Journal article I saw the following chart regarding Dropbox, YouSendIt and Box.com. The graph describes how many people use...
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...
How-to Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
