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...

How-to Make an Excel Bullet Chart

Executives and managers love to see gauge charts in their Excel Dashboards.  However, gauge charts may confuse or mislead the dashboard readers.  For instance,...

How-to Make a Pass Fail Chart in Excel

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...

Friday Challenge Answers – Food Donation Excel Dashboard Chart

Last week we presented a chart challenge to see how you represent Food Donation data.   Don said that we should keep it simple and sent...

Stacked bar chart with data from multiple columns – How would you do it?

5
Hello everyone!  Thanks for being a fan.  I am such a fan of Excel, that meeting MrExcel this week threw me off my schedule. ...

Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...

Don’t worry, Excel is not changing your chart to a Stacked Clustered Column Chart or Stacked Bar Chart when you move a data series...

How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...

Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?

2
First I want to say I am sorry to those waiting to see the dynamic chart scroll bar tutorial.  My project launched this week...

How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel

How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel On my post How-to Create a Stacked and Unstacked Column Chart I received...

SEO Performance Charts – Don’s Solutions

Sorry it has been a few days since my last post, but I have a lot that has been going on with new projects...