Does Tricare Cover Me If Im In An Auto Accident

The sparklines in Excel 2003-2007

In the last two articles we saw how to create graphics sparkline with the new feature introduced in Excel 2010.

In fact, almost nothing prevents you from creating your own graphics such: it suffices to create the chart, placing its upper left corner in its destination cell and resize it so it fills the cell .

Let the series "Apples" from the last article, create a histogram standard then realize the following: ●

then click on the legend [Delete] (or [Del] ) to destroy;

● click on the Y axis and then [Delete] (or [Del] ) to destroy;

● Right click on the X axis then "Format Axis", "Reasons" and disabling labels and markings;

● Right-click in the area tracing, "Format ..." and off curbs and aprons;

● click on a marker and then horizontal [Delete] (or [Del] ) to destroy them all;

● Right-click in the series and then "Format ..." "Options" and reducing the gap width between bars;

● resizing plot area to fill at best the chart area;

● travel with the key [Alt] key to anchor the top left of the graph in the top left of the target cell;

● Expansion the height of the row to 52.5 points and alignment of the entire line on the center (in the vertical dimension) ;

● resize with the key [Alt] key of the plot area so that its lower right is anchored in the bottom right of the cell.

The screenshot below shows what we got with Excel 2003, beneath a picture of the result we obtained with Excel 2010.

And voila! You just created your first sparkline in "hand-stitched!

Note 1 - Surely you can not (or at least not easily) put negative values in a different color, or attach a marker to extreme values, or first and last value ...

Note 2 - If the cell is not high enough, the bottom of the graph is truncated . That is why we assigned a height of 52.5 points at the line.

Note 3 - You can however put a cell in a pie chart or other graph type authorized by Excel, which is not possible with Excel 2010, but - in some cases - with possible additions (or add-ins) sparkline trade.

Note 4 - I did not put here an example of pie because my data contain negative values and the original Excel bug, which is to always draw pie charts by taking the absolute values series, has never been fixed!