http://blogs.office.com/b/microsoft-excel/archive/2011/03/01/use-the-data-axis-and-cell-merging-to-format-your-column-sparkline-chart.aspxSparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtimeen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2011/03/01/use-the-data-axis-and-cell-merging-to-format-your-column-sparkline-chart.aspx#25018Sat, 26 Mar 2011 18:38:53 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25018Gary Willoughby<p>Hi, Nippy -- note that I did not make this sparkline wider by dragging the fill handle in its cell -- if I did that, Excel would actually create an individual sparkline for each cell based on its position in relation to the data for the original sparkline. That is, Excel would assume I wanted a data range for each new sparkline based on the three cells to its right. So a new sparkline would be created in C3 with three data points, in D3 with two data points, and a sparkline in E3 would have one data point.</p> <p>Instead, what I did here was to select the sparkline cell (B3) and then select the three cells to its right with the mouse (or by holding down the SHIFT key and pressing the right arrow key three times). Then, I used the Merge Cells command on the Home tab to merge the cell that contains the sparkline (B3) with cells C3, D3, and E3.</p> <p>Using the Merge Cells command may give the same visual effect as dragging the lower-right corner of a graph object, but a graph is quite different from a sparkline. Hope this clears things up.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=25018" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2011/03/01/use-the-data-axis-and-cell-merging-to-format-your-column-sparkline-chart.aspx#25016Sat, 26 Mar 2011 06:09:29 GMT53587256-c606-4c9b-bad4-97c86b12ce62:25016nippy<p>in excel2010 graph dragging is not working. graph made in excel old version?</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=25016" width="1" height="1">