Dashboard
How-to Build a Plan vs Actual Excel Dashboard
Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released a great video tutorial on how to create your own Plan vs Actual Excel
EXPLORE THE LIBRARY
Tag: Excel Dashboard
Challenge
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data. Read it over, but really, the last line of the request is my favorite “other ways”. This can be with one chart
100% Stacked Column Chart
Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked Chart?
Friday Excel Challenge to Learn how to add percentages and value labels to the data series in an Excel 100% Stacked Column Chart or 100% Stacked Bar Chart.
Chart
Multi-Column Stacked Chart – How would you do it? – How I did it.
Step-by-Step Tutorial This is my solution to this week's Excel challenge. Learn how to put category names in a stacked column chart for your Excel Dashboard
Chart
Presenting Metrics Data – How would you create a chart for this data?
How to use multi-level category labels in Excel to present metric data
Conditional Chart
How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)
Tutorial and video on how to make an non-chart excel chart using conditional formatting techniques, tips and tricks. A NOAA National Weather Service Heat Index
Budget Analyst
Case Study – Mom Needing Help on Science Fair Graphs/Charts
I saw this posting on the ExcelForum site. Please read it, copy it to Excel and give some thought on how you would handle this challenge. Remember, a kid’s future is at stake . This is r
Bar Chart
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the tutorial and video demonstration of this technique here: How-to Put Percen
Chart
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
Excel Charts and Dynamic Dashboard for 2012 Summber Olympic Medal Count
Chart
How-to Put Percentage Labels on Top of a Stacked Column Chart
How to add a percentage label above an excel stacked column chart.