How to Use Sparklines to Highlight Data Trends in Excel 2010

Topic:  Microsoft Office, Excel  Product:  Microsoft Excel , Microsoft Office  Related Questions:  sparklines vertikal   linqpad trend data   highlight data browserfield blackberry  

In Microsoft Office 2010 Beta version, it provides more new applications and features. Among them, MS Excel offers more functions about tables. One of them is called Sparklines , which are mini-charts that you could place inside cells so that you can view the data and the chart on the same table.

Solution

  1. Open your Excel document in Microsoft Office 2010.
    Use Sparklines to Highlight Data Trends in Excel 2010
  2. Then select a location at the side of the table. And click "Insert" > "Sparklines" > "Column".
    Use Sparklines to Highlight Data Trends in Excel 2010
  3. The Create Sparklines dialog box appears, and type the range of data or click the "browse" button to select.
    Use Sparklines to Highlight Data Trends in Excel 2010
  4. Choose the data just like this and it will reflects in the form.
    Use Sparklines to Highlight Data Trends in Excel 2010
    Use Sparklines to Highlight Data Trends in Excel 2010
  5. Go back to the dialog box and click "OK".
    Use Sparklines to Highlight Data Trends in Excel 2010
  6. Well, you will see the columns right in the G column. In just one cell, you could see the trends of data in this row.
    Use Sparklines to Highlight Data Trends in Excel 2010

Tips

Here, you should pay attention. You can use this "sparklines" function just in Excel with "xlsx" format. And with "xls" format in Excel 2003 and earlier versions, this function is unavailable.

See also

How to Create a PivotTable from Worksheet Data in Excel 2010
A pivot table creates an interactive summary from many records. And in new Microsoft Excel 2010, the PivotTable has been replaced with "PivotTable" command on the "Insert" tab in the "Tables" group. It is a little different. Next, I will introduce how to create a PivotTable from Worksheet data in Excel 2010.
How to Use PowerPivot to Manipulate Large Data in Excel 2010
Office 2010 Beta has many new features including some special add-ins. Have you been troubled with dealing with large data worksheet in Excel? Now, you don't need to worry. Because PowerPivot for Excel, an add-in for Excel 2010, is a data analysis tool that delivers unmatched computational power directly within the application Microsoft Excel. It's a new tool for Microsoft Excel and I will give a brief introduction about how to use PowerPivot to Manipulate Large Data in Excel 2010.
How to Hide Data in Microsoft Excel
Sometimes, you want to hide some rows, columns or the whole worksheet for protecting data security or just edit contents conveniently. Excel offers the function of hiding data. Steps are as follows:

Search for Related Topics

cubic trend excel   sort sparklines 2010   cumulitive trend graphs excel   excel trend arrows barchart   draw trend pointer excel   select insert sparklines   trend import excel citect  

Related Unresolved Questions

more »
Options

Authors

Tagged Add my tag

excel 2010 , microsoft , office 2010 , sparklines , excel sparkline trendline , sparklines excel , trending excel , trend istogramma excel , chebyshev trend excel

Recent Searches

font kundli   rtmpt squid3   barrel distortion wpf   buzzdok eliminare   badoo itunes payments stop   1.0 2 download hindi indic input webdunia   download mediabar wincore