官术网_书友最值得收藏!

Zooming in on charts

If you are visualizing a dataset with a large number of values on the x-axis (the category axis), the chart might be a bit hard to use. To see a section of such a chart in more detail, we can use the range slider to zoom in on the data.

Note

The range slider option is available in the following chart components: line chart, OHLC chart, candlestick chart, column chart, bar chart, stacked column chart, stacked bar chart, combination chart, area chart, stacked area chart, and waterfall chart.

Getting ready

You can reuse any of the dashboards you have already made, which include one of the components mentioned previously. In this recipe, we will use the dashboard created in the Adding a line chart to your dashboard recipe.

How to do it...

  1. Select the chart then go to the Behavior tab and select the Common sub-tab.
  2. Select Enable Range Slider.
  3. Under Beginning Range Value select Category Label and enter value Q1.
  4. Under End Range Value also select Category Label and enter value Q3.
  5. Bind the Range Labels field to cells B4 until E4.
    How to do it...
  6. Go to the Appearance tab and select the Text sub-tab. Select Range Labels and set the text size to 8.
  7. Run the dashboard by hitting the Preview button and try the functionality of the range slider.
    How to do it...

How it works...

The range slider option makes it possible to select a section of the chart by sliding the beginning and end values of this range. In this recipe, we used category labels to define the initial range values. You can also choose to use the Position field and enter the position of the desired value in its series. Q1 would be position 1 and Q3 would be position 3.

主站蜘蛛池模板: 于田县| 晋宁县| 敦煌市| 措勤县| 海晏县| 永宁县| 乌拉特前旗| 监利县| 遂溪县| 尤溪县| 鸡西市| 秀山| 蛟河市| 称多县| 成安县| 吐鲁番市| 弋阳县| 垣曲县| 磴口县| 精河县| 灌阳县| 吉安市| 仁布县| 白城市| 平远县| 体育| 阜南县| 嫩江县| 遂溪县| 基隆市| 霍山县| 商丘市| 佛山市| 双流县| 都江堰市| 通河县| 北碚区| 河东区| 平泉县| 玛多县| 民丰县|