What is a sparkline? Explain how a sparkline can be inserted and its use.?
What will be an ideal response?
Answers will vary.Asparklineis a mini chart that is displayed entirely within a cell. The goal of a sparkline is to convey a large amount of graphical information within a very small space. They do not include chart elements such as legends, titles, gridlines, or axes. You can create three types of sparklines:?A line sparkline for highlighting trendsA column sparkline for column chartsA win/loss sparkline for highlighting positive and negative valuesSparklines can be inserted anywhere within the workbook and can represent data from several rows or columns. To create a set of sparklines, you specify a data range containing the data you want to graph, and then you select a location range where you want the sparklines to appear in the Create Sparklines dialog box. Note that the cells in which you insert the sparklines need not be blank. Sparklines are added as part of the cell background and do not replace any cell content.?The Sparkline Tools Design tab provides options for formatting the appearance of sparklines. Sparklines can show data markers to identify the high and low points, negative points, first and last point, and all points. Just select the check boxes for the markers you want to display in the Show group. As with other charts, the Style gallery in the Style group provides built-in styles for sparklines. In addition, you can specify the sparkline color and the marker color, which are also available in the Style group. The only other feature you can add to a sparkline is an axis, which for sparklines is simply a horizontal line that separates positive values from negative values. Click the Axis button in the Group group, and then click Show Axis. To remove sparklines from the worksheet, select the sparkline or sparklines to delete. On the Sparkline Tools Design tab, in the Group group, click the Clear button. Please see the section "Inserting and Formatting Sparklines" for more information.
You might also like to view...
Answer the following statements true (T) or false (F)
1. Most modern computers can understand and execute pseudo code. 2. Syntax involves rules that must be followed when writing a program. 3. Executable code is computer code that contains no errors. 4. IDE stands for internal data engine.
Macros can be used to automate complex tasks. Describe some of the steps that should be taken when developing these types of macros
What will be an ideal response?
Cost variances are not calculated by Project 2010.
Answer the following statement true (T) or false (F)
________ are squares and rectangles that rest on the Windows Start screen
A) Icons B) Tiles C) Scroll bars D) Charms