How-to Create a Step Chart in Excel with 3 Quick Steps
Here is the first and easiest answer to the challenge on posted on Friday.
In case you missed it, you can check it out and...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...
How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...
How-to Create a Time Data Series Step Chart in Excel
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...
How-to Add Label Leader Lines to an Excel Pie Chart
This a an awesome technique to make your pie charts stand out in your Excel dashboard. However, I didn’t know about it for the...
How-to Eliminate Statistical Outliers in an Excel Line Chart
Okay, I posted this Excel Chart Challenge on Friday. How did you do? I am sure your solution is better than mine. This was...
How-to Insert Slicers into an Excel Pivot Table
In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart
we described the best way to configure your data to easily create your next dashboard.
In this post, we explore the...
How-to Setup Your Excel Data for a Stacked Column Chart with a Secondary Axis
Many users have mixed reactions about this secondary axis overlap fix. You can see the post here:
Stop Excel From Overlapping the Columns When Moving...
How-to Make a Weekly 24 Hour Time Worked Gantt Chart in Excel
I have seen many questions where an Excel users want to know more about how to create a Gantt Chart using Time instead of...
How-to Make a Conditional Column Chart in Excel
As you build your Microsoft Excel dashboards, you may want to highlight your data points that exceed your Key Performance Indicators (KPIs) as well...






