speedometer chart is a combination of donut and pie chart. The chart looks like this:
To create a speedometer chart:
- Pažymėkite diapazoną H2:I6.
- Skirtuke Išplėstinė įsiuvas (Įterpti) skyriuje Diagramos (Diagramos) spustelėkite Visos diagramos (Other Charts) and select Anuliuoti (Doughnut).
- Next, you need to select each data point and use the command Pasirinkimo formatas (Format selection) adjust the fill of each element. Pay attention to the example shown below:
- For a series of dataspurga» The fill is set up as follows: the first three sectors have a different fill color (red, yellow and light green), and the fourth dot has no fill.
- For a series of dataAukštas» – the first and third points are not filled, and the second (smallest sector) is filled with black.
Data Series “spurga"Arba"Aukštas» can be selected on the tab Struktūra (Format). You can use the arrow keys to move from one data point to another.
- Select a series of data “spurga", Paspausk mygtuką Pasirinkimo formatas (Format Selection) and enter for the parameter Pirmojo sektoriaus sukimosi kampas (Angle) value 270 degrees.
- Select the diagram, right-click on it, in the context menu, click Diagramos srities formatas (Format Chart Area) and for the fill and border options, select respectively Nėra užpildymo (Not son) и jokių linijų (Jokios linijos).
- Delete the legend. Result:
- Select a series of data “Aukštas‘ and change the chart type for this series to Apskritas (Pie).
- Select a series of data “Aukštas", Paspausk mygtuką Pasirinkimo formatas (Format selection), for parameter Angle of rotation of the first sektoriai (Angle) enter a value of 270 degrees and select the series construction mode minor axis (secondary axis).Result. Data Series Plot “Aukštas” comprises:
- invisible colorless sector corresponding to the value 75,
- black sector-arrow corresponding to the value 1
- and another colorless sector corresponding to the value 124.
- Using the control skaitiklis (Spin button) change cell value I3 from 75 to 76. On the graph of the data series “Aukštas» changes will occur: the first colorless sector will reflect the value 76; the second black will remain equal to 1; the third colorless sector will show the value 200-1-76=123. Thanks to the formula in the cell I3 the sum of these three sectors will always be 200.
