Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Sparklines (RSS)

Browse by Tags

  • One More Sparkline Trick

    In this blog post I’ll walk through one more interesting way you can use sparklines in Excel 2010. In the above example we have the sales for each book category and for each store. While you can’t see the exact numbers in this view, you can get the feel for which sections sell well at the different stores. Let’s see how this is made with sparklines in Excel: There are actually 24 sparklines in the picture above; each one is bound to a single data point in a similar table with the numbers. You can...

  • A Sparkline Trick - Using the Horizontal Axis as a Reference Line

    In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have the data for the employee sign-up contest, this is a contest where employees try to get customers to sign-up for a bookstore club card. The contest has gone on for several weeks now, and each employee has a goal of 20 sign-ups per week. Right now the sparklines are conveying the history of sign-ups for each employee, for example...

  • Sparklines – Lining Up the Points

    In this blog post I’ll walk through some of the ways you can use sparklines in Excel 2010 using sample sparklines from the book store demo file: In the above example we have sales for each year, the cost of sales, and net profit for that year all divided by the category of book. One of the things you can do with sparklines in Excel 2010 is to stick them in cells above or below each other and have the points line up. Doing this will allow you to see trends for multiple fields in a related way. Here...

  • Sparkline Axis Options

    In this blog post I’ll walk through some of the axis options for sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the number of books by category for each month. The sparklines in this example are giving the history of the count of books for each category, and it looks like they are at their lowest over the past half year or so. Let’s take look at the axis options for these sparklines. Selecting the sparklines gives you a sparkline...

  • Formatting Sparklines

    In this blog post I’ll walk through formatting sparklines in Excel 2010 using sample sparklines from the book store demo file: The above sparklines are displaying the net profit by month for the three book stores in 2008. The net profit number alone can tell you which stores are doing well, but the sparklines help identify trends behind the number: Seattle and Houston both dipped in the summer, in general their profits climbed as the year went on, and Richmond didn’t do well until the last month...

  • Adding Some Spark to Your Spreadsheets

    In this blog post I’ll walk through creating sparklines in Excel 2010 using a sample table from the book store demo file: In the table we have the sales for the month of June: a column for total sales for the month, multiple columns for each day’s sales, and rows that break out different book categories. Sparklines will really be able to enhance the table and add to the understanding of the numbers by plotting out the month’s sales day by day in a single column, in line with the data. To get started...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.