How-to Highlight or Color Rings in an Excel Radar Chart
Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an...
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...
Date and Time Series Issues in Excel Charts
Many users think they are getting an axis error when they say that their column or line charts are showing every date between data...
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 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...
Grouping Excel Column Charts with a Box
In a previous post, I showed you how to group a column chart with lines:
You can check out the posting here:
Group Column Chart...
Excel Formula Formatting Quick Tip
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...
How-to Make a Conditional Column Chart in Excel – REDO
·
In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...
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...
