Excel Year on Year Charts - 5 Ways!

[@Oprimaita]

anyone who needs to display year on year charts should watch this tutorial. Thanks a lot.

[@MyOnlineTrainingHub]

So pleased you found it helpful :-)

[@arjasarkar13]

I absolutely agree - This was the best YoY chart tutorials. Highly appreciate the content.

[@birgitjohannes6804]

"I hope you find this useful" is always your sentence at the end of your videos. I find it much more than useful 😉, always on the spot and easy to understand. Your explanation about the differences between the chart types was really helpful as well as the techniques. I learned so much. Thank you.

[@MyOnlineTrainingHub]

Happy to hear that, Birgit!

[@PhyonLau]

I loved this video! Especially the overlap bar with difference width, very clean to show what you are talking about. Thank you so much!

[@MyOnlineTrainingHub]

Glad it was helpful! 🙏😊

[@Acheiropoietos]

I'm never disappointed with this channel; always something new and worthwhile.

[@MyOnlineTrainingHub]

Thanks so much!

[@paulsingleton6071]

I liked the Shift + Drag for the vertical alignment of the data labels Mynda. Thank you.

[@MyOnlineTrainingHub]

Glad you can make use of that technique, Paul :-)

[@IvanCortinas_ES]

Excellent compilation of graphs from year on year. Thank you very much for your professional explanations Mynda.

[@MyOnlineTrainingHub]

Glad you like them, Ivan!

[@TrangNguyen-xh7wh]

I just have to sign in & hit that like button because this is exactly what i needed. Thank you!

[@MyOnlineTrainingHub]

Thank you :-) Glad it helped!

[@brianbambrick-sattar3688]

Thank you and such an easy way to display useful information.

[@MyOnlineTrainingHub]

So nice of you, Brian :-)

[@teoxengineer]

Lynda, You're wonderful. I love your tutorials

[@MyOnlineTrainingHub]

Thankd so much, Emre!

[@mohammadshafiqmashal4272]

Thanks so much for your great work and explanation, Merci beaucoup pour cet travaille extraordinair.

[@MyOnlineTrainingHub]

My pleasure 😊

[@AR_Channel69]

Thanks, Miss. Your channel is good for learning. I like u, from Indonesia

[@MyOnlineTrainingHub]

Thank you! 😃

[@darrylmorgan]

Hi Mynda!Really Helpful Charting Tricks...Thank You :)

[@MyOnlineTrainingHub]

You're most welcome, Darryl!

[@chrism9037]

This was great, very useful. Thanks Mynda!

[@MyOnlineTrainingHub]

Cheers, Chris :-)

[@tejashmajmudar3025]

Very informative. Thanks a lot!

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@visuss1]

Very helpful tips ! Thank you !

[@MyOnlineTrainingHub]

My pleasure!

[@MlguelM]

Excelente Mynda! siempre aprendo algún truco nuevo con tus videos! muchas gracias!

[@MyOnlineTrainingHub]

Muchas gracias to you too, Miguel :-)

[@sanjaymali698]

Very useful video, Thanks for sharing, in a three years comparison if we want to see how much sales is generated in current year ie, 2021 in the example video- how do we do that? Please guide.

[@wayneedmondson1065]

Nice one Mynda! Very helpful charting tips. Thanks for sharing :)) Thumbs up!!

[@MyOnlineTrainingHub]

Cheers, Wayne :-)

[@khowajaghulamsakhisediqy1563]

Hi, Please prepare a video regarding below points: 1. How to create a chart with carved lines. 2. How to display min & max value of Trending line

[@MyOnlineTrainingHub]

I try to avoid the curved/smoothed line setting because the line often dips above/below the actual point and can be misleading. There's no automatic setting to display the min and max of a trendline.

[@khowajaghulamsakhisediqy1563]

@@MyOnlineTrainingHub Thanks for response.

[@RonNasty]

Thanks. I'm wondering if next time you could start from the wizard. Trying to re-create your features from the wizard created report was challenging. Also I had to stop and go back on numerous occasions to see where you clicked and added some elements. For example when you added a text box. You just added it out of thin air. It took me quite a while to figure out that one.

[@MyOnlineTrainingHub]

Apologies, Ron. There was an assumed level of knowledge for this video. If you'd like to get up to speed with Pivot Charts, please check out this tutorial: www.myonlinetraininghub.com/excel-pivot-charts

[@johnborg5419]

Thanks Mynda. That was very helpful. :) :)

[@MyOnlineTrainingHub]

I'm so glad, John!

[@bccabernet]

Another brilliant video Mynda!! thank you :D

[@MyOnlineTrainingHub]

Thank you!! 😊

[@juliehollandblubookkeeping8027]

been wanting to do this for months

[@MyOnlineTrainingHub]

Glad it was helpful!

[@motts913]

This video has saved me!

[@MyOnlineTrainingHub]

So pleased I could help.

[@mshi5826]

Thanks for your sharing. In 4:14, you add data label, I'd like to know if there is a way to change the color of -4% automatically. (Suppose there are a lot of negative value in other application.)

[@MyOnlineTrainingHub]

You can't conditionally format labels, sorry.

[@jengiuliano1143]

I love your videos too, always SO extremely helpful! Thank you so much!

[@MyOnlineTrainingHub]

You are so welcome!

[@kebincui]

Very good video. Thanks Mynda 😍😍

[@MyOnlineTrainingHub]

So pleased it was helpful 😊

[@ericgraham2665]

This was excellent!!! I really enjoyed watching this. I have a question. I need to sort data into a pie chart, showing items 1 year and younger and then 1-2 years, then 2-3 years and last 3+ years. Would you have a video showing how to do that? Or maybe some help?

[@MyOnlineTrainingHub]

I don't have any examples of this. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@drsteele4749]

Good info here, Mynda! Maybe one day you could do a vid on just how to use those buttons that always appear in pivot charts.

[@MyOnlineTrainingHub]

Thank you! The field buttons are just filter buttons on the face of the chart. The only useful ones IMO are the expand and collapse buttons: kzbin.info/www/bejne/f33Xk6Oio9GBjJY

[@clairezhang7351]

Absolutely great video. Thanks so much for sharing 😊

[@MyOnlineTrainingHub]

Glad you enjoyed it, Claire!

[@hazemali382]

Much Appreciated Mynda ♥

[@MyOnlineTrainingHub]

My pleasure, Hazem!

[@michaelsnow3213]

This is really helpful. Is there a way to test year on year from the midpoint of a year as opposed to the standard Jan - Dec format?

[@MyOnlineTrainingHub]

Hi Michael, if you're using PivotTables then you'd need to add a column to your source data to classify the dates into their fiscal periods as explained here: www.myonlinetraininghub.com/excel-slicers-for-fiscal-years

[@IqbalHamid]

My year data are in different worksheets. How do I create comparisons when the data to be compared lie in different worksheets?

[@MyOnlineTrainingHub]

You can use Power Query to consolidate the sheets into a single table: www.myonlinetraininghub.com/power-query-consolidate-excel-sheets

[@khey73]

Thanks again for a great video

[@MyOnlineTrainingHub]

My pleasure!

[@muhammadyaseen7719]

Appreciate you, very nice most informative videos. Keep sharing great work

[@MyOnlineTrainingHub]

Thanks, will do!

[@marioechave2839]

Genius! Thanks!

[@MyOnlineTrainingHub]

You're welcome, Mario!

[@mehmetarslan78]

Perfect... Thank you for sharing.

[@MyOnlineTrainingHub]

Glad you liked it!

[@tjaime01]

Is there a way to have a chart to show the current year seasonality compared to a certain period e.g. 10 years? Thanks.

[@MyOnlineTrainingHub]

I'm sure there is, Jaime. You just need to gather the data you want in the chart and it will display it. You could do this by tagging rows in the source data with an attribute and then you could reference that attribute as a filter. If you get stuck, post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@axelthyrion3477]

Thank you for all these great videos ! Super job :) I have one question and hope you'll be able to help : I'm working in retails and would need to compare yearly data based on their day of week. As an example will be easier to explain, I'm willing to compare the sales on let's say 1st April 2022 (which will be a Friday) vs the same Friday in 2019 (that was 5th April). At the moment, I've managed to get data by dates but it is only comparing to the same date year over year. Thank you in advance :)

[@MyOnlineTrainingHub]

You’re welcome 😊 You’ll need to add a column that gives each date its day of the year number and then use that column to make the comparisons.

[@simonmassen]

Love your videos, sooooooooooooooooooo useful. Thank you, keep up the great work

[@MyOnlineTrainingHub]

Thanks so much, Simon, will do :-)

[@stephanievulcheva8125]

Hello, could you please advise me on how to add a calculated field in a pivot table -> what %Of one field is another field, and to change the calculation of the percentages in order them to be accurately positive or negative if the two initial values are negative(as excel is not calculating them corrrectly)?

[@stephanievulcheva8125]

i mean on your pivot, if you had negative balance for the same month of two years you would see the calculation is wrong.

[@MyOnlineTrainingHub]

Hi Stephanie, I'm not sure what you mean. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@leorc564]

Excelente video, fácil y claro en el contenido, su técnica para transmitir la información es excelente, 8 minutos de tu vida que aportan valor, thank you Mynda for your knowledge!!,⚾️⚾️⚾️🔥🔥🔥⚡⚡⚡🇳🇮

[@MyOnlineTrainingHub]

My pleasure, Leonidas :-)

[@leorc564]

@@MyOnlineTrainingHub sus vídeos de Excel son los mejores, I really enjoy your channel.

[@vikramraghuwanshi9455]

Amazing vedi o

[@MyOnlineTrainingHub]

Thanks, Vikram!

[@rahulshewale9206]

Thank you

[@MyOnlineTrainingHub]

You're welcome, Rahul!

[@jamespyle6398]

How would you do a line chart but with multiple measures, say Revenue and Profit for instance? I can compare those for one year, but when trying to compare them year over year it gets pretty convoluted.

[@MyOnlineTrainingHub]

If you're looking at multiple measures, then it might be better to have the time axis continuous, i.e. from one year to the next, rather than multiple lines for each year.

[@grisheldamarks-webster-noa1706]

This is a different subject matter but your assistance will be greatly appreciated. I know how to set the scroll area so I won't fly down to row 1245. How do I save these changes. Whenever I close the workbook, the scroll range is deleted.

[@MyOnlineTrainingHub]

If you're setting the scroll area in the worksheet properties via the Developer tab then it should stick. I guess you could try saving the file as a .xlsm and see if that helps. I've not tested it to be honest.

[@grisheldamarks-webster-noa1706]

@@MyOnlineTrainingHub Hello, This did not work. You would be a genius if you figure this out. Thank you

[@jaspreetsingharora7070]

In this example you have used one set of values, What if we have 3 years, 3 different products and all the months. Is there a way to visualize it ? Thanks

[@MyOnlineTrainingHub]

I'd probably create 3 separate charts for the 3 different products. One chart would be too cluttered.

[@jaspreetsingharora7070]

@@MyOnlineTrainingHub Thanks.

[@rubperez2005]

Excellent! Happy to find your channel. Where can I buy the tshirt? :)

[@MyOnlineTrainingHub]

Thanks, Ruben! Microsoft don't sell the t-shirt anymore, but you can try searching online for other suppliers like Redbubble.com

[@RajendraPatel.]

Nice 👍

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@manoprem6521]

That's really great😎....

[@MyOnlineTrainingHub]

So pleased to hear that :-)

[@rakibahmmed1177]

I need a help, As we know Excel can load only 1,048,576 rows, but my power pivot table result need more than 2 millions of rows, that's why I don't load it in the general excel by power pivot, so I need to make the output into a CVS file. how can I do it....?

[@MyOnlineTrainingHub]

You'd need to use VBA for this. You could try copying and pasting the Power Pivot table to the CSV, but that's a lot of data to store on the clipboard and your PC might not like it.

[@hassanalianees5530]

brilliant

[@MyOnlineTrainingHub]

So pleased it was helpful!

[@samkab677]

Please help...I'm using data labels..I'm selecting from cells..I have zeros and like 0.3...i want only 0.3 to appear.. how to do it?

[@MyOnlineTrainingHub]

Your question isn't clear, sorry. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@newcreationeconomics2981]

I want to learn how to do it.

[@khairysyafieq3043]

tq madam

[@MyOnlineTrainingHub]

You're welcome!

[@fransvisser1517]

At the end: shouldn't it be '2020 to 2019' and '2021 to 2020'?

[@MyOnlineTrainingHub]

Hi Frans, these are financial years i.e. starting mid 2019 through to mid 2020, and the next financial year starting mid 2020 through to mid 2021.

[@Samcrazy4u]

❤️

[@MyOnlineTrainingHub]

Thank you!

[@Dante1877]

This video skips an early step and doesn't show how to format the data in the first chart by year/month so cannot progress beyond that step.

[@MyOnlineTrainingHub]

Hi Jason, did you download the example file linked to in the video description?

[@Dante1877]

@@MyOnlineTrainingHub Amazing, have downloaded the file and you are a lifesaver. Thank you