I let the video length be dictated by the topic. I'd rather produce something that is useful than stick to a time limit. Sometimes that means my videos are long, like dashboards :-)
Oh MY Life ! I learnt so many new tricks here! I so wished I had come across these sessions - 5-10 years ago. I would have saved my self a whole lot of time AND produced much better quality work. Thank you so much for sharing.
@@MyOnlineTrainingHub I have a research assignment and need to use Word and Excel but my research about why people think coding is hard! so I don't know how to do with Excel-like: what information to use it and compare can you give me some idea? Please I know we can use Excel for the number of tax year income but for my topic, I don't know.
This is very useful indeed. A sort of mini financial dash board. Experimented using your ideas where all the top line info , the Dimensions in rows .. Budget V Actuals and all the monthlies . Between the top lines and tables are 4 doughnut progress circles. Love it!
Hi Roberta, I don't know the Italian shortcuts, sorry. In the video you see that I left click and drag the range being referenced in the chart, I suspect you're adding them some other way if they're being added. If you're still stuck, please post your question and sample file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Not sure why you wouldn't be able to distribute vertically. The key is to have the charts at the top and bottom of the range in the positions you want, and then select all charts before distributing vertically.
In the chart...they're a bit small to show numbers in the chart. If you mean in the table of numbers, then you can use a custom number format to format negative values red: www.myonlinetraininghub.com/excel-custom-number-format-guide#_Toc474757765
Hello. I have sparklines that show the daily yield curve for U.S. notes and bonds. This data goes all the way back to 1990. Is there a way to animate these sparklines into some kind of slide show or video? I would like to show one sparkline at a time in rapid succession to show changes. There are nearly 8,000 sparkline graphs that I would need to display. Any advice?
Love your videos and hairstyle! Didnt know about alt-dragging, F4 and you can align vertically in between two charts till today! Just a feedback: do you think your logo (MyOnlineTrainingHub) in your spreadsheet needs some transparency love? :)
Thanks, Edward! I don't use a Mac, sorry. My limited knowledge understanding is that CMD is the equivalent of CTRL, but otherwise I'm not sure. You might find this keyboard cover useful: www.myonlinetraininghub.com/mac-excel-keyboard-shortcuts-cover
Thak you for this...but on the budget chart there is a someting unlogical...actual values bigger than budget is green colour.actual values smaller than budget is red colour:)))
If you're tracking sales values and actual is less than budget, then this is an adverse variance hence the red colour. If sales exceed budget then this is a positive variance, hence the green colour.
Hi , Greetings from New Zealand :) I'm so enjoying your great explanations :) I see you say Variance when, as a mathematician, I'd say Difference. We say Variance is the square of the Standard Deviation. Am I being fussy, or what?
Hi Stephen, It's great to hear you're enjoying my videos. As an accountant we say Variance when something is different to what we expect :-) it's a variance to the budgeted amount, or the budget has been varied to arrive at the actual amount.
F4. is it sad that F4 was my Favorite thing from this whole video. Thanks. keep doing great things. I wish there were ways around macro's as my company does not allow them in excel. Made me move to doing more stuff in access to get certain data and then link it back to the excel or a new excel file.
Great to hear you discovered some tips you can use. I wouldn't worry too much about macros. There is a huge amount you can do with Power Query to automate the getting and cleaning of data and it's much quicker and easier to learn. You can find out more about what Power Query can do here on my course page: www.myonlinetraininghub.com/excel-power-query-course No pressure to join ;-)
You could have taught how to make the series compatible... hard without it. Follow through this point. But stuck there, many line charts I have, to add a ghost series one by one is a pain
If you create the first chart with the ghost series you can just copy the chart and then point it at the new dataset while the ghost series stays in tact.
Great presentation! F4 is a great tip to work around Excel auto default formatting 👍 Do you have a video on how to permanently set chart formatting in a dashboard with interactive data? (4-charts Dashboard from Power Pivot) Many Thanks!
I presume you're referring to the problem where the formatting changes as you select a different item in the Slicer. If so, you need to clear all filters from the chart/Slicer, then set the formatting. That way you are formatting each series and when they are selected in the Slicer the formatting you applied will be displayed in the chart.
@@MyOnlineTrainingHub Exactly! Problem arise when I use multiple slicers in my dashboard, default chart formatting comes back. I will format my charts before creating the slicers next time. Thank you so much 😊
It is really useful video. I tried to follow your instructions but for me "Distribute Vertically" does not work. I assume this has something to do with mini chart size?
MyOnlineTrainingHub Actually, it is not “Distribute vertocally” problem. I think I have a problem with sizing a graph to fill in a cell with “Alt” key. Somehow i am not able to make a graph to fit a cell. Do you have any video that shows how to do this?
Never heard of it, but it looks similar to Power BI, but not as good. Example Power BI dashboard here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BsXliHbOFDM.html
See Home tab > Conditional Formatting > Icon Sets > Ratings group. This will give you fractions in quarter increments. Of course you can do a mini chart as a pie chart, but it'll probably be difficult to read.
Well done! Again. Some really interesting ideas. A couple of design pointers a) 20% or so of the general population has some form of colour recognition disability. The most common is Red-Green colour blindness. Please urge your audience to use colour palettes that accommodate such constraints. Never use Red/Green in such proximity. b) I would think for mini-charts choosing high contrast colour combinations would be very valuable given the compressed space.
I have Deuteranomaly which is the most common type of red-green colour blindness. I find that light-green against dark-red is ok, as is dark-green against light-red. But not both dark or both light.