I thought I would give you all something to do before we finish the final posting on Excel Chart Sheets.
So I have been traveling for work a lot and that allows me to read more Wall Street Journals in the hotel. I saw this graph in Monday July 28, 2014 WSJ.
It depicts a year by year difference between analyst forecast for the S&P 500 and the Actual S&P 500 gains.
Here is my rendition using Excel standard charts.
See if you can recreate it. Below is the sample data to get you started and the reset is up to you.
Sample Data: Recreate-this-Excel-Chart.xlsx
If you want to send me your chart, leave me a comment and I will send you an email where you can send me your sample chart.
Also, I am not quite sure what to call this chart/graph since it is not a standard Excel format. How would you describe this chart? Leave me a comment with your chart type name below.
I will show you how I created this in my next posting. Thanks for being a fan!
I would call it dual lollipop chart
I create a version pretty close to yours.
I nailed it.
I expected nothing less 🙂 Thanks playing the home game 🙂