Friday, April 29, 2011

Excel 2010 Charting with Sparklines

One of the new features in Excel 2010 is the ability to create a chart in one cell called Sparklines. They show how a range of data varies and can help people analyse their data and look at trends. Click on the Insert tab and in the Sparklines section choose Line. You will be asked to highlight your range of data and which cell you want the Sparkline chart to appear in.