Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month.
You can read more about the original challenge here:
Friday Challenge – Excel Mutli-year Graph by Month
Also, you can see and download the other samples here:
Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts
Friday Challenge Answer – Dynamic Excel Chart Using Checkboxes for Multi Year by Month Data
My solution to the challenge would be to create 2 charts:
1) A Excel graph that uses a picklist to displays all or highlights just one data series with the data grouped by years with in each month.
2) A Excel chart that uses a picklist to displays all or highlights just one data series with the data grouped by month for all years.
This is a very involved chart creation and so you want to check out how I did it here:
This embedded resource is unavailable in the restored edition.
You can download the Free sample file here:
Friday-Challenge-Excel-Chart-of-Months-by-Year-My-Solutions.xlsx
Let me know if you like this chart and if you can use it in your next Excel dashboard.
Steve=True
Reader discussion
Comments preserved from the original page. New comments are closed.
Reader
June 18, 2014 At 9:03 am
Beautiful! I tried, but could not get all the pieces to work. Great job.
Reader
June 18, 2014 At 1:43 pm
Thanks Don! That means a lot. Let me know what you had problems with as I will be writing it up as well and would like to know what is not working for folks. Thanks much!
Reader
June 18, 2014 At 5:01 pm
I did not mean that I could not get your graph to work. It worked great. I meant that I missed some big steps in trying to solve the challenge. I think the biggest thing I missed was your using one name for non-contiguous columns of data. The other thing was starting with a bar graph.
Again, great job.
Reader
June 18, 2014 At 5:35 pm
Wonderful. So cool to make a hard challenge for such a great Excel Guru. Thanks for the “great job” and glad you liked it. Steve=True
Reader
June 26, 2014 At 8:46 am
Great Job !!
I have a question; if the range of my data point is so large i.e. if Joe is doing around 10 while Larry is doing around 1000 then the Y axis will be stretchered and the small values (Joe’s values) will not be shown properly. is there any work around to make the Y axis flixsable based on the the pick list selection?
Thanks
Reader
June 27, 2014 At 11:14 am
Hi Obaida,
You can do this, but it may confuse the reader as the columns will be skewed and look closer than they values really are.
I will have to create a posting on this to show people how to do this.
Thanks