Under Style, you can change the styling for the graph. Under Show, you can add markers to the graphs like High Point, Low Point, Negative Points, First & Last Point and Markers (marker for every data point). Again, the Win/Loss is meant for data with positive and negative numbers. Under Type, you can change the type of mini chart you want. Starting from the left, you can edit the data if you like to include more columns or less. Now go ahead and click in any cell with a sparkline and then click on the Design tab under Sparkline Tools. By default, they are pretty tiny and can be hard to see properly. Now that we have our sparklines, let’s customize them! Firstly, you can always increase the size of the cells so that the graphs are bigger. To apply the sparkline to all the other rows, just grab the bottom right edge and drag it down just like you would a cell with a formula in it. Now click OK and your sparkline or tiny chart should appear in that one cell. Once you have selected the range, go ahead and click on the button again. A window should pop up asking you to choose the data range.Ĭlick on the little button at the right and then select one row of data. The Win/Loss type will only really make sense for data that has positive and negative values. You can always change the style later on, so don’t worry if you’re not sure which one will work best for your data. Pick from any of the three options depending on how you want the data displayed. First, click in the cell next to your data points, then click on Insert and then choose between Line, Column, and Win/Loss under Sparklines. So, how do we go about creating a sparkline? In Excel, it’s really easy to do. I should note that there is also a way to adjust the options so that the sparklines can be compared to each other also. Regular charts help you see trends between many rows or data and sparklines let you see trends within one row of data.
So you can see how the same data can be interpreted in different ways depending on how you choose to display it. In this chart, Store 8 is pretty much a flat line as compared to Store 1, which is still a trending up line. Next, on the Design tab, click Column (instead of Win/Loss) to clearly see how high and low the values are.For comparison purposes, I went ahead and created a normal Excel chart with the same data and here you can clearly see how each store performs in relation to the others.
#HOW TO CREATE SPARKLINES IN EXCEL 2011 DOWNLOAD#
Download the Excel file and select the sparklines. Win/Loss SparklinesĪ win/loss sparkline only shows whether each value is positive (win) or negative (loss). Note: now you can clearly see that the earnings of Jack are much higher. Under Vertical Axis Minimum Value Options and Vertical Axis Maximum Value Options, select Same for All Sparklines. On the Design tab, in the Group group, click Axis.ĥ. Note: all green bars have the same height, but the maximum values (B2, E3 and F4) are different!Ĥ. On the Design tab, in the Type group, click Column. To compare sparklines, execute the following steps.Ģ. The minimum value is plotted at the bottom of the cell. The maximum value is plotted at the top of the cell.
On the Design tab, in the Group group, click Clear.īy default, each sparkline has its own vertical scale. To delete a sparkline, execute the following steps.ĥ. Note: the high points are colored green now and the low points are colored red. On the Design tab, in the Style group, choose a nice visual style. Note: to make the sparklines larger, simply change the row height and column width of the sparkline cells.ģ. On the Design tab, in the Show group, check High Point and Low point. To customize sparklines, execute the following steps.Ģ. Excel automatically updates the sparkline. Click in the Data Range box and select the range B2:F4. On the Insert tab, in the Sparklines group, click Line.ģ.
0 kommentar(er)
