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...
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...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
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...
How-to Draw a Straight Line with Excel Shapes
Have you ever tried to draw a straight line in Excel only to get frustrated?
It can be so Frustrating :) to be off by...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
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 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 Stacked Clustered Column Chart with 2 Axes
In response to another post of mine, EC wrote:
“My issue: This site has been really helpful so far! I have a follow up question....
