sparklines

I am trying to add a Sparkline in its most basic form. My data set is 10, 8, 7, and 9. When I select the 4 cells in A1, B1, C1, and D1 and attempt to place the sparkline in E1 I receive an error message "Data source is not valid." Is there a setting or add-in that I need to enable? I am using...

I have a worksheet with 3,000 rows.. and each row has a sparkline... as such, it takes up quite a bit of processing power (and a few seconds) to display them all after I make any changes to the formula which they are based on. To make my life easier and speed things up a bit, I was wondering if...

Probably a stupid question, but why can't I use sparklines? In the Insert tab, that section (and the Filter - Slicer) section is faded and I can't select it. (Excel 2010)

Hi, I'm using Excel 2010 and am trying to insert the "Line" sparkline. My Data (numbers) is in the range "C2:G25" and I'm trying to insert the sparkline in column B (range "B2:B25") In the dialogue box, I enter C2:G25 in the "Data Range" and $B$2:$B$25 in the "Location Range" however, I get an...

I have created sparklines for multiple data sets and I want to use them in a PowerPoint document. I copy the information I want from Excel (including the sparklines) and have pasted in PowerPoint. When I try to print the document in color, everything appears BUT the sparklines. Does anyone...

I was trying to make Sparklines in xls 2007 but i think it is not possible....yea??? If not...pls advice...I have seen this in one of bill's videos and follow some intructions which i wasnt sure was the correct way..but want to learn how to do it...where is it located for xls 2007 Sparklines...

Hia all I am trying to make sparklines/microcharts and run into a problem.. How do i name the lines? (and group them afterwards?) Here is my code: ----------------------- Sub sparkline() limit = 30 'Fill Range with random numbers For Row = 1 To limit Cells(Row, 10) = Rnd(100) * 100 Next...

I am trying to run a macro to draw a number of bulletcharts as graphics (similar posting on the blog http://sparklines-excel.blogspot.com/) The process steps through each instance of the formula, draws a shape that fits into the indicated cell, then further shapes are combined to produce the...