dongxue7306
dongxue7306
2016-02-06 12:29

格式化HighCharts中的日期

已采纳

I have the following code:

  <script>
$.getJSON('https://www.quandl.com/api/v3/datasets/OPEC/ORB.json?order=asc', function(json) {
    var hiJson = json.dataset.data.map(function(d) {
      return [new Date(d[0]), d[1]]
    });

    // Create the chart
    $('#container').highcharts('chart', {
      rangeSelector: {
        selected: 1
      },
      title: {
        text: 'OPEC Crude Oil Price',
      },
      series: [{
        type: 'line',
        name: 'OPEC',
        data: hiJson,
      }]
    });
});

Which prints a beautiful chart as follows:

OPEC Crude Oil Price

But as you can see, the dates are not in the correct format. I am struggling to work out what is wrong?

All help much appreciated as always!

UPDATE:

So thanks to Holvar's comment I solved one problem, but now I have another on the same theme.

My code is as follows:

<script>
$.getJSON('https://www.quandl.com/api/v3/datasets/BOE/IUAAAMIH.json?auth_token=pg6FBmvfQazVFdUgpqHz&start_date=2003-01-02&order=asc', function(json) {
    var hiJson = json.dataset.data.map(function(d) {
      return [new Date(d[0]), d[1]]
    });

    // Create the chart
    $('#interest').highcharts('chart', {
      xAxis: {
        type: 'datetime',
        dateTimeLabelFormats: {
                          day: '%Y'
                      }  
      },            
      rangeSelector: {
      selected: 1
      },
      title: {
        text: 'UK Interest Rates',
      },
      series: [{
        type: 'line',
        name: 'Interest Rate',
        data: hiJson,
      }]
    });
});

But this produces a chart without dates on the bottom. I'd like years from 2003-01-02. The chart looks like this

UK Interest Rate

I don't understand why it's not showing an annual date as in the solution to the initially posed question?!

You help is much appreciated!

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • dsbc80836 dsbc80836 5年前

    I believe the issue is with the way the data map is happening. The ending array contains multiple arrays, instead of an object with "x" and "y" properties. Try changing the initialization of the hiJson variable to something like:

    var hiJson = json.dataset.data.map(function(d) { return { x: new Date(d[0]), y: d[1] }; });

    That seems to be working on my local environment.

    点赞 评论 复制链接分享