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...

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...

How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial

Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph.  However, this...

Friday Challenge – Eliminating outliers in and Excel Chart

Okay, apologies again .  I have been so swamped with my Go-Live project this week that I have been too tired to finish the...

Group Column Chart with Lines for Excel Dashboard Presentations

Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...



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 Draw a Vertical and Horizontal Line that Intersect in an Excel Chart

Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...

Chart of Tiger Woods Victories on PGA Tour and in Majors

Tiger Woods PGA Tour and Major Championship Chart

I am a fan of the PGA and Tiger Woods.  So I was really excited when I saw this post from Paresh Shah of...

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...



How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link