Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Missing X-axis labels
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Missing X-axis labels
#58520
Missing X-axis labels 1 Year, 3 Months ago Karma: 0
Hello. I created a column chart that shows age distribution:



As you can see, it only shows '2' at the center in the X axis, and no Y axis labels at all. How to fix this?
Below is the SQL code:

Code:

SELECT
  COUNT (CASE WHEN datipersonali.dp_eta >=0 AND datipersonali.dp_eta <=17 THEN 1 END) AS 'Errore',
  COUNT (CASE WHEN datipersonali.dp_eta >=18 AND datipersonali.dp_eta <=20 THEN 1 END) AS '18-20',
  COUNT (CASE WHEN datipersonali.dp_eta >=21 AND datipersonali.dp_eta <=30 THEN 1 END) AS '21-30',
  COUNT (CASE WHEN datipersonali.dp_eta >=31 AND datipersonali.dp_eta <=40 THEN 1 END) AS '31-40',
  COUNT (CASE WHEN datipersonali.dp_eta >=41 AND datipersonali.dp_eta <=50 THEN 1 END) AS '41-50',
  COUNT (CASE WHEN datipersonali.dp_eta >=51 AND datipersonali.dp_eta <=60 THEN 1 END) AS '51-60',
  COUNT (CASE WHEN datipersonali.dp_eta >=61 THEN 1 END) AS '61+'
FROM datipersonali
GROUP BY 'Errore', '18-20', '21-30', '31-40', '41-50', '51-60', '61+'

The administrator has disabled public write access.
 
#58521
Re:Missing X-axis labels 1 Year, 3 Months ago Karma: 670
Hello,

Could you save a HTML page with the chart and send it by email?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58522
Re:Missing X-axis labels 1 Year, 3 Months ago Karma: 0
e-mail's on its way
The administrator has disabled public write access.
 
#58523
Re:Missing X-axis labels 1 Year, 3 Months ago Karma: 670
Set "ARI GChart -> Column chart -> Chart area width" parameter to 90% value.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#58530
Re:Missing X-axis labels 1 Year, 3 Months ago Karma: 0
That is for the Y axis, but the X axis (horizontal) is still showing only one label, the first value of the table.
The administrator has disabled public write access.
 
#58539
Re:Missing X-axis labels 1 Year, 3 Months ago Karma: 670
Column charts show label in X axis. Your chart contains only one label "2" and it is shown.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12