Excel - create a chart from Subtotals and fill in missing data by Chris Menard 

You're the best! I have been following you for years, thanks from France for taking the time

Easy to follow and very to the point, I love this. No 5 min intro. As a person that only occasionally work with Excel, this is a life saver.

Las Vegas, NV: First, that Ctrl+Enter trick is fabulous!! What a time saver and accuracy ensurer! Second, if you had warned we'd be talking about "Power Query Editor", I would have backed away, thinking, oh that sounds way too advanced, but you slyly slipped it right in there, and it wasn't scary at all! Thanks so much, Chris! Love your style.

Thank you for the detailed information! I would like to ask you a question: I create subtotals using the Average function. When I plot the results, how can I erase the word "average" from the abscissa?

Great insights! Any chance you know how to graph sub and grand-totals from a pivot table? Thanks, in advance!

Cannot get to the last step. Somehow Alt+F1 doesn't work on my laptop. I tried to work around with Insert/Chart but it does not work easer. What to do?

Great tutorial.