You have several customization options here. To edit a sparkline, click on it and choose the Design tab on the ribbon. Then the range should be the same number of columns as your data). (Unless you want to chart columns instead of rows. Pick a range that is the same number of rows as your data. The Create Sparklines dialog box will appear, asking you to choose a location for the sparklines. In the Sparklines group, choose one of the 3 types (Line, Column, or Win/Loss).
Then select just the cells with temperature data, not the cells listing the months or the cities. If you want to chart the average monthly temperature in different cities, create a table of the average temperature each month for each city.
To create sparklines, you start with a table of numerical data, just like you would with any other chart. Line sparklines help you see data trends and answer questions like these: How much does my data fluctuate? Does it trend upward or downward? What are the high and low points? Here is an example with temperature data for a few cities (sample data from ).Įxample of sparklines showing win/loss records. Inserting a sparkline using the new Insert > Sparklines feature in Excel 2010+ is much easier.Įxcel 2010+ provides 3 types of sparklines: Line, Column, and Win/Loss. But that takes a lot of time and can be tricky to get the graphs just the way you want them. If you want to, you can make a sparkline with Insert > Chart and take the time to shrink the new chart, re-size the axes, and get rid of all labels. Sparklines are different from other Excel charts because they are smaller, don't have labels, and show only one line of data. Edward Tufte defines sparklines in his book, Beautiful Evidence: " Sparklines are data-intense, design-simple, word-sized graphics." Sparklines are small, simple charts that are easy to make, easy to understand, and small enough to fit in a single cell alongside your data. Now let's consider the feature in Excel known as Sparklines. Would you rather wade through a table of data or look at charts? You'll probably say charts, maybe because they help you see data trends and interpret numbers more easily.
0 kommentar(er)
