This useful video shows how to use a graphical representation of data in a single cell through the use of Sparklines. I think Sparklines are one of the exciting and cool charting features introduced in Excel 2010. Sparklines allow you to view and analyze data without creating an entire chart. You can quickly and easily spot trends at a glance and add rich visualization capability to tabular data without taking up too much space. We choose this video as it shows how you can create and customize sparklines and how you can highlight certain points like:- High and low points, Negative [More]
Click here to Download the spreadsheet used in this presentation Create an Excel Chart Budget vs Actuals chart using the clear instructions in this video the Queen of Excel Charts Mynda Tracey. The video is divided into two parts – the first showing how to create a Excel Chart Budget vs Actuals chart in Excel 2007/2010 and the second part (starting at around 8 mins) shows how to create the same graph in Excel 2013. The video shows some cool tricks along the way to creating the Excel Chart Budget vs Actuals chart – Including how to cut and paste [More]
Excel panel charts are usually created by taking more than one area chart and lining them up so they look like one chart. In this video you can see how you can set up one of the panels and then use some pretty cool cut and pasting techniques to line the charts up to start to form a panel chart. Once you have one of the charts set up you will see it is easy to copy and change the necessary details for each panel. There is a very cool top at 4 minutes that shows you just how easy [More]
Excel 2013 has a neat hidden feature in it that allows you to do some really quick analysis of data and this video walks you through all the options available in the Excel 2013 Quick Analysis feature. I have been using Excel 2013 for about 6 months now and I did not even know about this feature – shame on me! I always love it when Mynda Treacy releases one of her videos for free viewing and this one is no exception. I am a big fan of her work at My Online Training and have taken her Excel Dashboard course in [More]
I hope you enjoy this video – if you are inspired to create better charts then you should check out our recommended Excel Dashboard Course Excel Dashboard course that is currently open for registration again. A funnel chart is often used to show how a process generates results. the most common use for a Funnel Chart would be to show how users convert on your website, from visitors to leads to sales. This video clearly shows how to create a funnel chart in the first 4 minutes but what I really like about this example is it shows you just how configurable [More]
The more I get into Excel Dashboards the more excited I get. This is a great video that I hope will give you some ideas and techniques to present lots of data on a number of Excel Charts. This video is a little longer than the ones I usually post but it is well worth 15 – 20 minutes of your time. The video looks at a large table of sales data from a number of US states. If you put all the states on a graph at the same time then there is no way you can see any [More]
We love the videos produced by MyOnlineTrainingHub as they are always really clear and easy to follow. This one shows an advance charting method to show Quintile Charts for a real life case study of English Schools. If you are not sure what a Quintile chart is (like us before we watched the video) then the easiest way to find out is to simply watch the video.
This great video shows you how to liven up a chart within your Excel worksheet by adding an image in the background of the chart. It is amazing what a difference adding an image to the back of a chart can make. One minute a boring bar chart the next minute it looks very professional. You do have to watch out for images that clash with your charts – you want the viewer to focus on the data not the image at the end of the day.
This video is taken from the Excel Dashboard course run by Mytraininghub – read my full review of this course here The video shows how you can add text labels to the title of a graph so that when the data the graph is plotting changes the title keeps in sync with the data. It is a surprisingly simply idea and as you will see from the video it is easy to do and the presenter explains it very clearly.
This is one of the longest videos on the site but it shows one of the most useful in showing you how you can make charts in Excel to be dynamic. The video contains a lot of information and it uses excel scroll bars to make a slider on the spreadsheet, then it shows how to use Vlookup to take the value from the slider and look up the values to be plotted. Finally it shows a small VBA routine that shows you how to animate the graph at the click of a button.
This video shows you how to create a frequency distribution chart using an array formula. there are a number of ways to create a frequency distribution chart in Excel, you can use a pivot chart, create a set of equations using countif or the method contained within this video. You need to pay special attention at the part when the formula is copied down – the Ctrl Shift Enter combination is vital when you copy the equation.
Speedometer charts are a great way to add style to an Executive report or dashboard in Excel. There is no direct option to create speedometer charts in Excel but with a few clever tricks you can create all sorts of effects with Excel charts. This video shows several of these tricks and as you will see the outcome is quite simple but at the same time very clever. This Video is for Excel 2010 only.