AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() And you can see that it is summarizing the values I selected, B2 through B13. I will drag the dialogue box out of the way, and with the cursor flashing in the "Select where to place sparklines" box, I will click cell F2. And now I need to select where I want to place the sparkline. B2 through B13 so it appears within the box. Doing so displays the create sparklines dialogue box, and I can select the data range. I will start by selecting cells B2 through B13, and then on the insert tab of the ribbon, I will click the sparklines button, and click line. ![]() Lets say that I want to summarize revenue as a line chart, but I need to make it very small. I have the actual revenue in column B, the target revenue against which revenue will be compared in column C and the difference. This workbook contains a series of monthly results. My sample file is the Sparkline Workbook, and you can find it in the Chapter 7 Folder of your Exercise Files Collection. In this movie I will show you how to create them, and point you to the formatting tools you can use to change their appearance. You can create three kinds of sparkline charts Excel Line, column and win/loss. Sparklines, which were invented by Edward Tufte, and detailed in his book Beautiful Evidence, summarize data in a compact word-sized chart, that fits inside a single worksheet cell.
0 Comments
Read More
Leave a Reply. |