How-to Use Data Labels from a Range in an Excel Chart
Excel 2013 has some cool features. If you were not aware, here is an awesome Chart Data Label option that you now have when...
New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting
Excel Flash Fill
Every time a new version of Excel is released there are always new features that are hard to find and learn for those...
Customizing the Standard Excel Chart Titles
Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may...
Why is Excel Overlapping Columns When I Move them to the Secondary Axis?
Why is Excel Overlapping Columns in this chart? Why EXCEL, WHY are you doing this??? I don’t understand. Have you ever asked yourself this...
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...
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
Here is a Friday Challenge that a lot of Excel users may run into.
Essentially, you are given a date and incident type that occurred...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
Friday Challenge Answers: Year over Year Chart Comparisons
Thanks for the submissions for the Friday Challenge.
You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons
Here are some other submissions:
A) In the...
Excel Geek Out with MrExcel
How fun a night I had! Did you ever think that you would meet a couple of Excel gurus and other Excel fans and...
Friday Challenge Answers – Graph Increase at Time Interval
Hello everybody. We had a two answers submitted by our friends Don and Pete. Surprisingly, they had the same thought.
They both thought that the...
