Here are some interesting Operating system and softwares tips and tricks 4u.JUST CLICK ON THE PICTURE IN THE BLOG FOR ENALARGED VIEW.

sd

Thursday, February 23, 2012

Visualize data values in worksheets individually(Excel 2010)

              One of the great features of Excel 2010 is the inclusion of Sparklines that allow you to visualize the data of the selected cells in the form of charts. It makes it easier to analyse the data and spot trends.
              Sparklines is the newest, most interesting feature of Excel 2010. It allows you to simultaneously visualize your data in the form of bar, profit or loss displays in the same sheet. It also includes various other options that further increase its efficiency.
               Mark the desired series of data and go to the ‘Insert’ tab here you will find the Sparklines option next to the Charts. Here select the display option from Row, Column or Profit/Loss. Once you select an option you will see a box ‘Create Sparklines’, you will fi nd your selected data range now feed the location range i.e. the area where you want the display the Sparklines. Confi rm with ‘OK’ and the Sparklines will be displayed in the desired area.
               This will also activate the ‘Sparklines Tools under the Design Tab, which allows you to make changes to the Sparklines. You can display the Sparklines according lowest or highest points, negative points, fi rst or last points etc. You can also change the colour for each Sparkline or even individual Markers.
               If you wish to delete the Sparklines you can do so as well. You also have the option to Group the Sparklines together and then from here you can either remove an individual Sparkline or remove the entire group.

0 comments:

Post a Comment

please write your comment

Note: Only a member of this blog may post a comment.

THE WINDOWS TRICKS Headline Animator