![]() To format the sparklines click on a cell with a sparkline in it, go to the Design tab of the ribbon and select the formatting element you want to change. Each sparkline is charting only the data in that row, even though we entered the entire range at once. Click OK and the sparklines will be placed in column E. Then at Choose where you want the sparklines to be placed enter E2:E5 or highlight cells E2 to E5 with your mouse. You can either highlight those cells with your mouse or type A2:D5 in the data range. At Choose the data you want enter the range of cells that hold your data, in this case that would be from A2 to D5. In the Sparklines section choose either Line, Column, or Win/Loss depending on which type of chart you want.Ī window will open. To add Sparklines in column E, select cell E2, go to the Insert tab on the ribbon. In this table we have a list of sales by sales rep, with a column for each month. Choose the area for the data you want summarized in the chart, then choose where you want the chart to be displayed. To insert a Sparkline, go to the Insert tab of the ribbon, in the Sparkline section choose Line, Column, or Win/Loss. They are mini charts that fit within a cell in an Excel worksheet so you can have your numbers and your chart too. What if you could have both at the same time? That is where Sparklines come in. But often you need the detail that is on those numbers. Charts and can help show trends that are hard to pick out of a large table of numbers.
0 Comments
Leave a Reply. |