When creating a chart sparkline, we can create more of a blow. is what we have done here by selecting L1: L3 then stating that the chart took its data in the block B1: K3. We can thus gain time by creating three charts at once, but with the disadvantage that these three graphs are then linked. As soon as you click in one of them, three are selected.
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 ...
0 comments:
Post a Comment