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

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.

主站蜘蛛池模板: 泸溪县| 新蔡县| 滁州市| 临澧县| 丘北县| 宽城| 高阳县| 拉萨市| 铁力市| 大城县| 塘沽区| 安平县| 奈曼旗| 汤原县| 奈曼旗| 东城区| 浪卡子县| 广河县| 龙州县| 广德县| 河北区| 桐梓县| 吉水县| 河西区| 清河县| 建始县| 博客| 杭锦旗| 濮阳市| 威宁| 林州市| 合阳县| 兰西县| 陆丰市| 临汾市| 武胜县| 策勒县| 巢湖市| 丹棱县| 乐陵市| 大渡口区|