Shulou(Shulou.com)06/01 Report--

This article mainly explains "what is Area in sparklines". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is Area in sparklines".

In fact, it is our common area map (or area map), which and the line chart (mentioned yesterday) are used to show the trend and fluctuation range in the time series, and then evaluate the development state of things.

Yesterday's line chart was misreported because of the problem with the code version, so that it only gave an introduction to the syntax and did not show the diagram. I hope today's Area can go smoothly.

The parameters of the area map are relatively few, so it is easy to understand:

= AreaChart (Points;Mini;Maxi;Line1;Line2;ColorPosition;ColorNegative)

Where Points is the index parameter, you should enter a row or a column of cell ranges, and it is also a necessary parameter for the area graph function.

Mini;Maxi these two parameters are the limit of the high and low values of the vertical axis of the mini chart, in fact, it can be understood as the maximum and minimum values of the vertical axis (the default can be used, but if you customize, you must remember that the maximum value must at least be greater than or equal to the maximum value of the actual index, or there will be incomplete cases in the chart).

Line1;Line2: these two parameters can set up a pair of upper and lower parallel lines around the horizontal axis for the mini-area map, which you can understand as a comparison reference line for positive and negative indicators. (if customized, it should be defined between the actual maximum and minimum values of the metric.)

ColorPosition;ColorNegative: these two parameters are easier to understand. Positive and negative areas are filled with colors. (you can query it according to sparklines's exclusive color matching code table).

The following is an example of setting the Area parameter in the sparklines menu in excel:

= areachart (D3glaze I3recovery50pr 100pr 30pr 50pr 2112496 pr 5546802)

Through the function filling function and changing the negative area color code, you can instantly complete the drawing function of all the following data (Excel is really powerless, you can only copy, or annoying VBA (but you have to write).

After this mini-graph is done, it can be used as a template for at least a period of time, and the order can be used to replace the data, and to tell you a secret, in fact, the finished chart is a completely vector independent graphic combination, which means that you can copy the chart directly, and then disband the combination to change the color of the subdivided graphics in the chart at will and enlarge the use of the chart will not affect the clarity.

Thank you for your reading, the above is the content of "what is Area in sparklines". After the study of this article, I believe you have a deeper understanding of what the Area in sparklines is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.