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

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.

主站蜘蛛池模板: 金阳县| 永登县| 阳西县| 连州市| 临沭县| 博白县| 大田县| 徐闻县| 普定县| 宝山区| 平果县| 青浦区| 漯河市| 木兰县| 佛教| 吉木萨尔县| 常宁市| 临安市| 天柱县| 江山市| 修水县| 澳门| 凯里市| 桃园市| 松江区| 延长县| 江西省| 勃利县| 礼泉县| 福州市| 台湾省| 湘潭市| 临夏市| 宝清县| 米泉市| 宁海县| 馆陶县| 错那县| 博湖县| 和静县| 定安县|