-
回答 1 已采纳
I'm using highcharts for generate my reports, but, an little problem for showing the numbers at columns from highchart... In fact, two problems..
First problem:
Second Problem:
This are problems is occurring of form random...
If you look at the first example has all the numbers at the top of the columns ...
And the second example has all the values inside the columns, however, with problem to display the values at the top of the column.
I would like to know if there is any possibility of forcing the Highcharts API to display this data at all times.
Example Chart:
chart = new Highcharts.Chart({"chart":{"renderTo":"adwords_leads_all_94-3088","type":"column"},"title":{"text":"Leads AdWords - Convers\u00e3o - (Call Tracking | Chatbot | Formul\u00e1rio)"},"colors":["#68a9dc","#005a64","#003f23","#e4452b","#65c07f","#004b76","#6ecbd6","#ff7754","#83ccb0","#007b5a","#ec9631","#24a1ae","#e46a2b","#b6740c","#f79969","#1b964e","#fdc076","#147bb6","#ba0d00","#1d6c3f"],"xAxis":{"categories":["Mar\/2018","Abr\/2018","Mai\/2018","Jun\/2018","Jul\/2018"]},"yAxis":{"min":0,"title":{"text":"Quantidade"},"stackLabels":{"enabled":1,"style":{"fontWeight":"bold","fontSize":"16px","color":"#000"}}},"legend":{"align":"center","verticalAlign":"bottom","backgroundColor":(Highcharts.theme && Highcharts.theme.legendBackgroundColorSolid) || 'white',"borderColor":"#CCC","borderWidth":1,"shadow":false},"tooltip":{"formatter":function() {
return '<b>'+ this.x +'</b><br/>'+
this.series.name +': '+ this.y +'<br/>'+
'Total: '+ this.point.stackTotal;}},"plotOptions":{"column":{"stacking":"normal","dataLabels":{"enabled":1,"color":(Highcharts.theme && Highcharts.theme.dataLabelsColor) || 'white'}}},"series":[{"name":"Call Tracking","data":[0,99,454,297,409]},{"name":"Chatbot","data":[51,150,155,106,97]},{"name":"Formul\u00e1rio","data":[19,107,184,138,150]}]});
-
回答 1 已采纳
The problem is when the x-axis categories array reaches index "50", it will not show all categories in x-axis. Instead it will just alternate. But when I print the $chartArray['xAxis']['categories'] variable it has values from index 0 to index 50.
This is the figure up to index 49.
This is the figure up to index 50.
-
回答 2 已采纳 
highcharts饼状图如何将数据显示成这样。在图形上放不下时用线条指引，放的下时放入图形上显示。求大佬告知！！！！！！
-
回答 1 已采纳
I am trying to create a simple program that takes weather data from my database that I have setup, and display it on a webpage. The way I have it setup right now is that you have to enter a value in the text box in order to get the data to pull.
My HTML Code:
<!DOCTYPE html>
<html>
<head>
<title>Database</title>
</head>
<body>
Name: <input type="text" id="name">
<input type="submit" id="name-submit" value="Grab">
<div id="name-data"></div>
<div id="container" style="min-width: 310px; height: 400px;
margin: 0 auto"></div>
<script src="http://code.jquery.com/jquery-1.8.0.min.js">
</script>
<script src="js/global.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"> </script>
</body>
</html>
My PHP Code:
<?php
if(isset($_POST['name']) === true && empty($_POST['name']) === false) {
mysql_connect("localhost", "root", "Logilube163");
mysql_select_db("Weather_Test_Simple_Schema__Rev1");
$query = mysql_query("SELECT * FROM Location");
while($row = mysql_fetch_array($query)){
$time = strtotime($row['time']) * 1000;
$tempF = $row['temp_f'];
![enter image description here][1]$data []= [(int)$time, (int)$tempF];
}
echo json_encode($data);
}
?>
The code is able to query my database, and put the data into the data array $data.
The array of data is then encoded using the json_encode(); function and is transferred to the javascript file where it is successfully being read out and placed in a on the html page.
My JS code:
$('input#name-submit').on('click', function(){
var name = $('input#name').val();
if($.trim(name)!=''){
$.post('/ajaxdb/ajax/name.php',{name: name}, function(data){
$('div#name-data').text(data); // Outputs the data before the graph
$('#container').highcharts({
chart: {
zoomType: 'x'
},
xAxis: {
type: 'datetime',
minRange: 24 * 3600000
},
title : {
text : 'Weather Data'
},
series : [{
data: data // <-- This data is not being read in by the graph
//[[1432813308000,78],[1432813904000,77],[1432813968000,77],[1432814016000,77],[1432815600000,78],[1432832464000,66],[1432843057000,65],[1432843731000,65]]
//The above data is read in by the graph and plots just fine.
}]
});
});
}
});
My output result looks like this:
The problem is that this same data that is read out in the javascript, and is not being able to be placed in the highcharts graph. Instead, the chart gets created with the correct axis but without any data points. However, when I enter the data points being created by the tag, the data gets plotted just fine.
-
回答 1 已采纳
I have input all of my data in controller and view. I took data from database anyway. When I try to run my code, not all of the data appeared in chart display.
For example, I want to display 11 data in xAxis. But, only 10 data that can be displayed in xAxis.
I have table like this:
I have controller like this: https://pastebin.com/M2QFF73V
I have view like this: https://pastebin.com/cZ2B4hXM
my codes result:
there is year 2015 in table but why 2015 didn't display in chart? why the chart just displayed 10 data?
How to display all of data?
Thanks in advance
-
回答 1 已采纳
I'm a new by in javascript. I want to plot a stack bar chart by using highcharts in my website. I copy the demo code here, then paste it in my php localhost, but there's no highcharts in my website. what's the problem?
code↓
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="https://code.highcharts.com/highcharts.js"></script>
<script type="text/javascript" src="https://code.highcharts.com/modules/exporting.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
$("#container").highcharts({
chart: {
type: 'column'
},
title: {
text: 'Stacked column chart'
},
xAxis: {
categories: ['Apples', 'Oranges', 'Pears', 'Grapes', 'Bananas']
},
yAxis: {
min: 0,
title: {
text: 'Total fruit consumption'
},
stackLabels: {
enabled: true,
style: {
fontWeight: 'bold',
color: (Highcharts.theme && Highcharts.theme.textColor) || 'gray'
}
}
},
legend: {
align: 'right',
x: -30,
verticalAlign: 'top',
y: 25,
floating: true,
backgroundColor: (Highcharts.theme && Highcharts.theme.background2) || 'white',
borderColor: '#CCC',
borderWidth: 1,
shadow: false
},
tooltip: {
headerFormat: '<b>{point.x}</b><br/>',
pointFormat: '{series.name}: {point.y}<br/>Total: {point.stackTotal}'
},
plotOptions: {
column: {
stacking: 'normal',
dataLabels: {
enabled: true,
color: (Highcharts.theme && Highcharts.theme.dataLabelsColor) || 'white',
style: {
textShadow: '0 0 3px black'
}
}
}
},
series: [{
name: 'John',
data: [9, 10, 4, 7, 2]
}, {
name: 'Jane',
data: [8, 5, 3, 2, 1]
}, {
name: 'Joe',
data: [7, 7, 4, 2, 5]
}]
});
});
</script>
</head>
<body>
<h2 align="center">HighCharts.js demo</h2>
Where's the plot?<br>
<div id="container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>
</body>
</html>
-
回答 1 已采纳
JSON output: (from dt.php)
[{
"name":"Year",
"data":[2012,2013]
},{
"name":"A",
"date":[111,24]
},{
"name":"B",
"date":[34,0]
},{
"name":"C",
"date":[365,43]
},{
"name":"D",
"date":[496,0]
}]
Javascript:
$(document).ready(function() {
var chart;
var option = {
chart: {
renderTo: 'hcChart',
type: 'column'
},
title: {
text: 'Testing'
},
xAxis: {
categories: []
},
series: []
};
$.getJSON("dt.php", function(json) {
option.xAxis.categories = json[0]['data'];
option.series[0] = json[1];
option.series[1] = json[2];
option.series[2] = json[3];
option.series[3] = json[4];
chart = new Highcharts.Chart(option);
});
});
The chart does show out with the legends but the there are no single value showing up.. Any help?
-
回答 2 已采纳
I have a query. I want to display a pie chart using the highcharts api. The data is coming from a MySQL database. My table is like (THIS IS MY TABLE FORMAT):
city|area|blank
A |100 |50
B |50 |20
My PHP code is
<?php
include "con.php";
$id = $_GET['city'];
$result = mysqli_query($con,"SELECT area AS A , blank AS B from `table` WHERE city = '".$id."' ");
$rows['type'] = 'pie';
$rows['name'] = 'area';
//$rows['innerSize'] = '50%';
while ($r = mysqli_fetch_array($result)) {
$rows['data'][] = array($r['A'], $r['B']);
}
$rslt = array();
array_push($rslt,$rows);
print json_encode($rslt, JSON_NUMERIC_CHECK);
mysqli_close($con);
I have been displaying a pie chart but my data was like this (THIS IS EXAMPLE):
id|category|value
1 |area |100
1 |blank |20
2 |area |50
2 |blank |20
but as I mentioned regarding my table structure earlier, the pie chart is not displaying with it.
My js code:
var c = $('#City :selected').text();
getAjaxData(c);
var opt = {
chart: {
renderTo: 'container1',
plotBackgroundColor: null,
plotBorderWidth: null,
plotShadow: false
},
title: {
text: 'final chart'
},
plotOptions: {
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: true,
color: '#000000',
connectorColor: '#000000',
formatter: function() {
return '<b>' + this.point.name + '</b>: ' + this.y;
}
},
showInLegend: true
}
},
series: []
};
function getAjaxData(c) {
$.getJSON("file.php", {city:c},function(json) {
opt.series = json;
chart = new Highcharts.Chart(opt);
});
}
-
回答 2 已采纳
I got a table like:
product
id | product_id
1 55
2 56
3 57
product_options
id | product_id | options_value
1 55 88
2 55 87
3 55 89
... ...
I want to select all option_values from product_options where product_id from product is same with product_id from product_options.
After I select all fields from product I use this:
$sql .= " LEFT JOIN " . DB_PREFIX . "product_option_value ovi ON (ovi.product_id=p.product_id)";
if(...){
$sql .= " AND ovi.option_value_id='$value'";
}
The problem is: If I only got one options_value, it's fine.
but when I have 2 or more options_values the result is 0.
i want to select all options_value from product_options for all product_id from product_options
PS. Sorry for my english and explication
-
回答 1 已采纳
With my symfony command, I want to display an array of multiple data. How to fill the fields of my table in an automatic way as I tried to do in my example?
$table = new Table($output);
$table->setHeaders(array('ID', 'Date'))
->setRows(array(
foreach ($productsCursor as $product) {
array($product->getId(), $product->getCreated()->format('Y-m-d H:i:s')),
}
));
$table->render();
-
旭东怪的博客 原始效果图： 实现代码： <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8">...script type="text/javascript" src="js/jquery.min.js">... -
nest9527的博客 Highcharts 柱状图显示0值会给人造成误解，毕竟0值和空值是两个结果 解决方案： 将数据源0值替换为null -
-
weixin_39559523的博客 这就不得不提到图表编辑界的大佬Highcharts它是一个用纯JavaScript编写的一个图表库顾名思义它能够很简单便捷的在web网站或是web应用程序添加有交互性的图表并且免费提供给个人学习、个人网站和非商业用途使用划重点... -
误凡尘的博客 方法一：在Axis（包括xAxis和yAxis）有一个属性tickInterval，number类型，表示间隔，也就是间隔多少个值显示，比如设置为5，则表示每隔5个值才显示一个，在上面的基础上，经过设置tickInterval值为5，效果如下: ... -
weixin_39844284的博客 在Excel中，用这个数据生成的图表一般是这样的：细心的小伙伴们可能很快就会发现，这个堆积柱状图没有累加的数据标签。没错，在Excel中用常规的方法做出的堆积柱状图就是这样的。这是硬伤，需要用点小技巧才能实现... -
RoffeyYang的博客 在本教程中，我将以一种简单的方式解释什么是Sankey图以及如何使用Highcharts创建它。 Sankey图表可方便地说明不同级别的多个元素之间的数据流（演示：2017年美国能源消耗的估计流量）以及一个或 -
jacksonary的博客 我这里是利用的ajax进行轮询的机制实现的： &amp;lt;!-- highChart插件的使用 ，这个是可以实现动态数据的更新--&amp;gt; &amp;lt;script type=&...Highcharts.setOptions({ glob... -
Bill-Zhang的博客 HighCharts开发实际上配置HighCharts每个部分，比如配置标题（title），副标题（subtitle）等，其中每个部分又有更细的参数配置，比如标题下有对齐方式（align），标题文字（text）等。下图为整个图表的每个部分位置... -
匆匆7231的博客 HighCharts开发实际上配置HighCharts每个部分，比如配置标题（title），副标题（subtitle）等，其中每个部分又有更细的参数配置，比如标题下有对齐方式（align），标题文字（text）等。下图为整个
