"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.
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.
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: ruclips.net/video/ILtbplnlNV4/видео.html
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.
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
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.
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!!,⚾️⚾️⚾️🔥🔥🔥⚡⚡⚡🇳🇮
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 :)
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?
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
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
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.)
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)?
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
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
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.
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.
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.
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.
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....?
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.
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
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
I loved this video! Especially the overlap bar with difference width, very clean to show what you are talking about. Thank you so much!
Glad it was helpful! 🙏😊
"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.
Happy to hear that, Birgit!
anyone who needs to display year on year charts should watch this tutorial. Thanks a lot.
So pleased you found it helpful :-)
I'm never disappointed with this channel; always something new and worthwhile.
Thanks so much!
Excellent compilation of graphs from year on year. Thank you very much for your professional explanations Mynda.
Glad you like them, Ivan!
I just have to sign in & hit that like button because this is exactly what i needed. Thank you!
Thank you :-) Glad it helped!
I liked the Shift + Drag for the vertical alignment of the data labels Mynda. Thank you.
Glad you can make use of that technique, Paul :-)
Lynda,
You're wonderful. I love your tutorials
Thankd so much, Emre!
been wanting to do this for months
Glad it was helpful!
Thank you and such an easy way to display useful information.
So nice of you, Brian :-)
Excelente Mynda! siempre aprendo algún truco nuevo con tus videos! muchas gracias!
Muchas gracias to you too, Miguel :-)
This was great, very useful. Thanks Mynda!
Cheers, Chris :-)
Thanks, Miss.
Your channel is good for learning.
I like u, from Indonesia
Thank you! 😃
Thanks so much for your great work and explanation, Merci beaucoup pour cet travaille extraordinair.
My pleasure 😊
Nice one Mynda! Very helpful charting tips. Thanks for sharing :)) Thumbs up!!
Cheers, Wayne :-)
This video has saved me!
So pleased I could help.
Much Appreciated Mynda ♥
My pleasure, Hazem!
Another brilliant video Mynda!! thank you :D
Thank you!! 😊
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
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.
@@MyOnlineTrainingHub
Thanks for response.
Very informative. Thanks a lot!
Glad you enjoyed it!
Very helpful tips ! Thank you !
My pleasure!
Hi Mynda!Really Helpful Charting Tricks...Thank You :)
You're most welcome, Darryl!
I love your videos too, always SO extremely helpful! Thank you so much!
You are so welcome!
Very good video. Thanks Mynda 😍😍
So pleased it was helpful 😊
Thanks Mynda. That was very helpful. :) :)
I'm so glad, John!
Absolutely great video. Thanks so much for sharing 😊
Glad you enjoyed it, Claire!
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.
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: ruclips.net/video/ILtbplnlNV4/видео.html
Perfect... Thank you for sharing.
Glad you liked it!
Genius! Thanks!
You're welcome, Mario!
Thanks again for a great video
My pleasure!
Amazing vedi o
Thanks, Vikram!
Love your videos, sooooooooooooooooooo useful. Thank you, keep up the great work
Thanks so much, Simon, will do :-)
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.
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
Appreciate you, very nice most informative videos. Keep sharing great work
Thanks, will do!
brilliant
So pleased it was helpful!
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.
Thank you
You're welcome, Rahul!
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!!,⚾️⚾️⚾️🔥🔥🔥⚡⚡⚡🇳🇮
My pleasure, Leonidas :-)
@@MyOnlineTrainingHub sus vídeos de Excel son los mejores, I really enjoy your channel.
Nice 👍
Thank you! Cheers!
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 :)
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.
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?
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
Excellent! Happy to find your channel. Where can I buy the tshirt? :)
Thanks, Ruben! Microsoft don't sell the t-shirt anymore, but you can try searching online for other suppliers like Redbubble.com
That's really great😎....
So pleased to hear that :-)
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?
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
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.)
You can't conditionally format labels, sorry.
My year data are in different worksheets. How do I create comparisons when the data to be compared lie in different worksheets?
You can use Power Query to consolidate the sheets into a single table: www.myonlinetraininghub.com/power-query-consolidate-excel-sheets
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)?
i mean on your pivot, if you had negative balance for the same month of two years you would see the calculation is wrong.
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
tq madam
You're welcome!
Is there a way to have a chart to show the current year seasonality compared to a certain period e.g. 10 years? Thanks.
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
I want to learn how to do it.
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.
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.
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.
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.
@@MyOnlineTrainingHub Hello, This did not work. You would be a genius if you figure this out. Thank you
❤️
Thank you!
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....?
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.
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?
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
At the end: shouldn't it be '2020 to 2019' and '2021 to 2020'?
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.
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.
Hi Jason, did you download the example file linked to in the video description?
@@MyOnlineTrainingHub Amazing, have downloaded the file and you are a lifesaver. Thank you
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
I'd probably create 3 separate charts for the 3 different products. One chart would be too cluttered.
@@MyOnlineTrainingHub Thanks.