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
EXPLORE THE LIBRARY
Tag: Video Demonstration
Challenge
Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution
In the recent Friday Challenge: Create Pipeline Usage Chart A user wanted to create a bar chart where the values had a specific color by product and also matched represented the size of the
Challenge
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge, Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time where a user wanted the following: Creating a graph of cumulative events over time I
Help
How-to Quickly Get Excel Function Help Plus a Bonus Tip
In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the AverageA Excel function. So I thought I would share how I q
Alt-Code
How-to Add a Rupee Symbol or a Music Note or a Chess Piece to a Custom Excel Number Format
A reader, Matt, after reading this post: How-to Format Chart Axis for Thousands or Millions And had the following question: “How do you use this formula without the dollar sign? I am using d
Excel 2013
Touch vs Mouse Mode in Excel
With all the new affordable touch screen computers out there, you may have purchased one. However, if you are like me, you may have large fingers and trouble using your laptop’s touch capab
Challenge
Chart Increase at Time Interval in Excel
Create a chart that can indicate at what time a value increased in a certain column of data.
Chart Sheet
How-to Add Multiple Charts to an Excel Chart Sheet
How-to Add Multiple Charts to an Excel Chart Sheet
Challenge
How-to Make a Wall Street Journal (WSJ) Double Lollipop Chart in Excel
In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ). Here is what our final chart will look like: Hopefully, the challenge didn’t th