Chart
Terrible Chart Tuesday – Leader Lines
So in yesterday’s post, I showed you that in Excel 2013, you can now add leader lines to your Line Chart. They are not just reserved for Pie Charts like in previous versions of Excel. But I
EXPLORE THE LIBRARY
/tag/excel/page/9/
Chart
New Chart Label Leader Lines Available in Excel 2013
Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013? I didn’t know this until just recently. I never thought to look. I always thought that they were only ava
Chart
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
Chart
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,
Challenge
Friday Challenge: What is your answer vs. Excel?
There is a Facebook post going around and I thought it would be a fun Friday Challenge edition. What is your answer to this this question? Then put in the formula into Excel and see what you
Chart
Think Like a Database Designer Before Creating an Excel Dashboard Chart
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let me pr
Excel tutorial
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
Goto
How-to Quickly Find and Jump to the Right Worksheet Tab in Your Excel Workbook
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create more tabs than you can see on the bottom of the s
Challenge
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 not date based, but time based. The use case is a medical study on s
Challenge
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request: Hi Steve, I am trying to make a hypnogram with data that we collected over the course of a day. I want the y-axis to denote wake (W), o