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]
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.
I like this video as it talks a little about how to best present lots of data in a pie chart as well as showing you some really cool tips and tricks in making the visual appeal of the pie chart much higher. The video covers how to add labels and when to use exploded pie charts. The link on the video does not download the XLS file that is used to create the pie charts in the video but I have recreated the file and you can download the XLS file from here
Bubble charts (sometimes called XYZ plots or point maps) allow to you change the size of a symbol based on a third value. These charts can be useful if you need to show three types of data per data point. The X and Y are the same as they are for normal graphs but the Z value then controls the size of the point/bubble. What I like about this video is that is shows you how to add images into the bubbles and label the points with you own labels. This is really useful and as you will see from [More]
This short video shows a clever method for controlling how the bars on your bar charts are stacked. In this video you will learn how to control the bar chart Axis text, adjust the thickness of the bar and how to group data together so sets of data sit side by side. This last item is the real highlight of the video and something I had not seen done before – I hope you find it as useful as I have. This video has been supplied by our friends at www.Myonlinetraininghub.com who have a fantastic set of Excel training videos [More]
This video shows you how you can have more than one type of chart type on a single chart (often called a combination chart). In the video an example is used to show how to have one data set shown as a bar chart and one set of data as a line chart. Pretty cool! The trick is to use the second scale option on the graph using the format data series options. The video gives a clear and easy to follow example – which we can probably related to. This video is taken from the missing manual books. If [More]