We continue our small hopping from island to island chip, sometimes 50 minutes! The fact remains that the navigation must be done under certain conditions: always have the sun in the back or navigate between 12 and 14:00 and never arrive at night, moving slowly when approaching the coral monitoring at the bow with polarized glasses to distinguish colors.
It remains only to minimize the gap between the plot area and chart area, then embed the graph into a cell to obtain the desired sparkline
... Here's the macro, and the screenshot of original graph and graph processing. You have to activate the graph before running the macro ...
Sub Cleanup ()
ActiveChart.Legend.Delete
ActiveChart.Axes (xlCategory). Select
With Selection
.MajorTickMark = xlNone
.MinorTickMark = xlNone
.TickLabelPosition = xlNone
End With
ActiveChart.ChartGroups(1).GapWidth = 20
ActiveChart.Axes(xlValue).Delete
ActiveChart.SeriesCollection(1).Interior.ColorIndex = 5
ActiveChart.PlotArea.Interior.ColorIndex = 19
ActiveChart.Axes (xlValue). MajorGridlines.Delete
End Sub 
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!
is convenient in some cases. Here, for example, we requested the display of the X axis and it is immediately apparent in the three graphs. Similarly, replacing the default color of the histogram by a blue sky here applied in the three graphs.
The disadvantage is that it is so much more difficult to change a graph separately. That's why we created three graphs in column M independent.
Note that we can change numerous settings is selected when a sparkline: marking negative values (cf. cells M1 and M2), changing colors, marking the end points, marking the first and last point Adding axes (see screenshot above) ...
Note - Note that the command to change the line thickness is not easy to find: you have to go, as we see in the screenshot above, the command "Colors sparkline. It would have been more logical to add a command "Line width" to previous menu ...
It's time for us to leave this beautiful and enchanting city of Cartagena ... Too touristy, some say! True, but it is normal because there is so much to see! And then, do Remember that for years the country has been "wiped" of travel destinations because of the Farc, insecurity in the cities ... Hotels, restaurants, etc. ... have suffered enormously. The Government did a great job on it, police are everywhere, a bit too much for us Europeans ... but it is true that at no time do we feel we are in danger! Indeed, the slogan of the latest campaign of the Government, where humor has definitely replaced the fear is "Colombia, the only risk is wanting to stay" ... But we must continue the journey as it takes us closer to the Panama Canal ... We will still take the time to stop by the famous San Blas Islands, inhabited by the Kuna Indians. You can find the photos, which promise great, until we are back in modern civilization (in about 3 weeks), only text messages appear on the blog. Bizzzzzzzzzzz you all
Microsoft filed the patent in May 2008, to the chagrin of Edward Tufte and others and professionals (see http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=0003Y1&topic_id=1 ). Hopefully all this will find a solution ... honest
A sparkline is a graph that fits in a single cell in your spreadsheet. Initially, it was only curves (hence the term "line"). The sparklines are in Excel, through various add-ins (or supplements) for several years already.
These graphics are built into Excel since the 2010 version of the software. We see in a later article how to proceed with earlier versions of Excel.
In this first article we see how to create a first sparkline with Excel 2010: the cursor is in D2, we activate the tape "Insert" and activate the curves tool in Block "sparkline Charts." Here's how we filled dialogue:
The result is shown below, with further two new graphs with, for the same set of digital data, the histogram and the corresponding positive / negative partner.
Note 1 - In version "Positive / Negative", there is no indication of the absolute value, but only the distinction Positive / No / Negative.
Note 2 - The histogram default can not see well that there are negative values in the series, but we'll see how to fix this in the next section.
Yesterday morning we take a taxi to be 08.00 Bazurto the Mercado, the largest market town. From there, go to the island of lanchas Baru, where the Playa Blanca, about 3.5 km long. "The amigo" seen the previous day to take us there, not here! Phew "Lendro" offers us the same thing, the start is coming soon but ... we will wait two hours before leaving! Mercado Bazurto, huge market "African", with its colors and especially ... smells! Small vendors, restaurateurs, individuals etc. ... flock here from the first light, we must not forget that Cartagena has almost 1.2 million inhabitants ... but we are not "come" inside, it's not for tourists! Within 2 hours of waiting, we saw happen in the wood, food, jerry cans for diesel ... a big engine, then we said we would surely sink! Thirty passengers, half a dozen children and we finally leave! After 3/4h nav, playa blanca is before our eyes, it's true that she's pretty with its white sandy beach, small "huts", hammocks to rent for the night, the deck chairs or under small shelters ... In 1 or 2 hours, there will be many people because the big shuttle will arrive, so we put away, leaving chairs and chairs, because for us the beach is a sarong on the sand and then basta ! After swimming, drowsiness creeping over me (Jo), where my hand grinds the trapezius muscle and left a voice says "um, mama, mucho mucho stress. Paola is it mass with aloe vera, it's nice, I let myself do ... she asks me where I am and when I told him that I am French, she said "mama, mucho mucho ingles work mucha tension," I can not help but laugh ... Massage all over, I find myself with a good layer of aloe vera from the hairline to the feet, the sand sticks to it, super ... 13.30, a small snack is needed, we return to the "shacks" to find what we eat and thus put in the shade because the sun burns. Shrimp marinated and grilled, slightly sweet rice, tortillas, tomatoes, delicious! It is time to approach near lanchas "Lendro" we said "very soon the" ... Floating pontoons come for passengers of large buses, the wind picked up and waves as well. Good waves come to "slam" at the beach, the laborers have become difficult, people panicked a bit and still no "Lendro! We will ask a policeman who told us that there will be more lanchas and to return to Cartagena, take the boat is still there. We do sign the driver of the pontoon floating it back, the waves are big, it can not, then we go into the water, Eric, wearing the backpack as "commando" rises first, I found myself with water up to his neck, a guy handed me his arm I grabbed me and managed to pull myself up ... whew I have not lost the sunglasses!
Cross the 16th century overlooking the Bocagrande district of ... 21st Century! - The patio and its well
A little gold! - Hello girls
At Carmela - We love the doors of houses
