How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart

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

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

Group Column Chart with Lines for Excel Dashboard Presentations

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

Using the Camera Tool to Create a Vertical Line Chart in Excel

1
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...

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 Decades and Highlight a Year in the Horizontal Axis

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

Friday Challenge – Mimic Newspaper Chart Line Style in Excel

Hi All, Here is a fun challenge that I thought you might like.  I  saw this chart in the Denver Post and I wondered how...

3 Ways to Create Vertical Lines in an Excel Line Chart

35
Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish.  We...

How-to Mimic a Newspaper Chart Line Style in Excel

In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart...

Dashboard Chart of Tiger Wood’s Money Ranking List and Golf Earnings

0
With the upcoming Open Championship (also known as the British Open) in Royal Lytham & St. Annes Golf Club, I wanted to see how...