How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart
How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart
A stacked area chart displays an area of points above other data points...
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart...
How-to Create a Sick Leave Excel Dashboard Chart
Okay, I got an email from a SUPER FAN of my sight. She even donated some money to help cover the costs of that...
How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart
Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
How-to Group and Categorize Excel Chart Legend Entries
If you have a chart with Legends, then you should check out this tutorial.
Recently when working on a solution for a fan, I noticed...
Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair.
You can read more about it here:
Case...
Create a Vertical Line Between Columns in Excel Using Error Bars
Create a Vertical Line Between Columns in Excel Using Error Bars
Thanks to Leonid (a super fan) for advising me on another and possibly better...
How-to Create Modify and Delete an Excel Pivot Table Calculated Field
I am sure you have created a Pivot Table in your Excel Workbook. However, have you wanted to easily learn how to add a...
How-to Format Chart Axis for Thousands or Millions
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...