Merry Christmas from Excel Dashboard Templates

0
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 Doughnut Chart. I used pictures of garland for the wreath parts...

Grouping Excel Column Charts with a Box

0
In a previous post, I showed you how to group a column chart with lines: You can check out the posting here: Group Column Chart with Lines for Excel Dashboard Presentations Then I received a question...

Budget Analyst Question: My Answer

3
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 stacked bar graph to show the amount we spent and...

The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components.  For instance, I used the conditional formatting in a Tiger...

Budget Analysts – How would you answer this Excel Chart question?

0
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive team, managers or co-workers.  I would like you to read...

How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...

0
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your Excel Dashboard Components.  Now this may be causing you one...

How-to Create a New York Times Tiger Woods Chart in Excel

0
In a past article, I posted 2 different ways to make a chart that appeared in the New York Times.  Here is the chart and you can see the post with this link: Tiger Woods...

How-to Make a Wall Street Journal Horizontal Panel Chart in Excel

0
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 Dropbox vs YouSendIt vs Box.  As you can see by...

How-to Make an Excel Vertical Likert Line Chart with Categories

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

Customizing the Standard Excel Chart Titles

0
Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may not be aware.  In this post, you will learn how...