Week seven, session: 2 Reflextion

Sparklines: A sparkline is a type of information graphic characterized by its small size and high data density. Sparklines present trends and variations associated with some measurement, such as average temperature or stock market activity, in a simple and condensed way. Several sparklines are often used together as elements of a small multiple.

The term sparkline was proposed by Edward Tufte for "small, high resolution graphics embedded in a context of words, numbers, images".[1] Tufte describes sparklines as "data-intense, design-simple, word-sized graphics".[2] Whereas the typical chart is designed to show as much data as possible, and is set off from the flow of text (as in the following diagram), sparklines are intended to be succinct, memorable, and located where they are discussed.

There are 3 types of sparklines .
.

For using sparkline3 1^st we have to select the cells that we will need for first sparklines.then we have to click the insert tab, in the sparkline group select a line, a dialog box will appear. Click the cell where we want to sparkline to be, then click ok and at last the sparkline will be created for the remain rows.

Pivot table : In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name. The term pivot table is a generic phrase used by multiple vendors. However, Microsoft Corporation has trademarked the specific form PivotTable.

.

we work with chart then we reviewing and sharing work books, track changes, how to add and delete comments, finalizing and protecting our work book.