Excel Dot Plots, Dumbbells and Lollipop Charts Made Easy! - My Online Training Hub
video description
I am tradinng on stocksmarkets an all my trades is registrated in a sheet in a excellworkbook one sheet for every equity. At the moment I have a sort of a Dashboard where I summerize everything by refering to the cells in the sheets and it ia a nightmar for me to update it every month as I get morre and more sheets every month.
The sheets them self contains entreies of buy and sell and som calculation of different kinds so the change every time a buy that stock.
I have looked at to your videos concer power query, one where you transform all the sheets in to one tabel and one where you link the sheets to a tabel. Which method would you use if you where me?
Date: 2022-04-08
Related videos
Comments and reviews: 7
Brannan
Hi Mynda -MyOnlineTrainingHub -- this is a phenomenal video, you walk through and explain everything so well! I had been using Tableau to kick out these types of charts for years, but it's so helpful to know that I can do it much quicker in Excel instead :)
Just ONE question that I'm struggling with -- if I want to have the Department Names anchored along the left side of the chart (in other words, to the left of where the Y-axis ticks would be) -- how do I do this? Is this possible? This would look better on some of my data compared to having the department names floating out in the scatter plot along with the data points
reply
Hi Mynda -MyOnlineTrainingHub -- this is a phenomenal video, you walk through and explain everything so well! I had been using Tableau to kick out these types of charts for years, but it's so helpful to know that I can do it much quicker in Excel instead :)
Just ONE question that I'm struggling with -- if I want to have the Department Names anchored along the left side of the chart (in other words, to the left of where the Y-axis ticks would be) -- how do I do this? Is this possible? This would look better on some of my data compared to having the department names floating out in the scatter plot along with the data points
reply
James
Thank you, Mynda. So many good ideas in your videos, so many files to download (not a bad thing) !
To me, the X-axis labels in both the dot-plot and dumbbell charts are the only chart elements that one might consider cluttered at all. Was there a particular reason for you to keep the intervals at $50M, or would intervals at $100M be just as effective?
reply
Thank you, Mynda. So many good ideas in your videos, so many files to download (not a bad thing) !
To me, the X-axis labels in both the dot-plot and dumbbell charts are the only chart elements that one might consider cluttered at all. Was there a particular reason for you to keep the intervals at $50M, or would intervals at $100M be just as effective?
reply
Kevin
I'm making a pre-post dot plot table and I got to your error bar portion where you say to switch to the x-axis (horizontal). I have excel for mac and they only allow me to edit the vertical error bar. Do you have any ideas on how to edit horizontal error bars in the mac version of excel?
reply
I'm making a pre-post dot plot table and I got to your error bar portion where you say to switch to the x-axis (horizontal). I have excel for mac and they only allow me to edit the vertical error bar. Do you have any ideas on how to edit horizontal error bars in the mac version of excel?
reply
Bianca
Hi Mynda, thank you so much for putting up this video, it really helped me a lot. I have one question, what if I have three series (2010, 2019, and 2020) and the newest series value is lower than the earliest series (2020
reply
Hi Mynda, thank you so much for putting up this video, it really helped me a lot. I have one question, what if I have three series (2010, 2019, and 2020) and the newest series value is lower than the earliest series (2020
reply
Wayne
Hi Mynda. Thanks for showing how to create these non-built-in fun chart types. Always amazing how you manipulate and assemble the components to build a new solution! Thanks for sharing :)) Thumbs up!!
reply
Hi Mynda. Thanks for showing how to create these non-built-in fun chart types. Always amazing how you manipulate and assemble the components to build a new solution! Thanks for sharing :)) Thumbs up!!
reply
Philippe
Great Video. Thank you!
Question: Is that also a way to make -Time Line Charts- using dates and dates (needed for marketing activities i.e.)?
Or is there a better way for doing that?
reply
Great Video. Thank you!
Question: Is that also a way to make -Time Line Charts- using dates and dates (needed for marketing activities i.e.)?
Or is there a better way for doing that?
reply
Emre
Hi Mynda, I have a trouble for -Dept. D- negative error values. The Graph doesn't draw negative line in chart though I follow your instructions.
How can I send you my screenshot?
reply
Hi Mynda, I have a trouble for -Dept. D- negative error values. The Graph doesn't draw negative line in chart though I follow your instructions.
How can I send you my screenshot?
reply
Add a review, comment
Other channel videos
