I am facing an issue with my column chart where JSON data is being parsed in the "normal" form: Years are displayed on the xAxis and values on the yAxis (check out the fiddle here):
array(
array(
"name" => "Bangladesh",
"data" =>
array(
array(2000,27892),
array(2010,56199)
)
),
array(
"name" => "Sri Lanka",
"data" =>
array(
array(2000, 10170),
array(2010,12720)
)
)
)
Now, I want to change the display format: countries should be on the xAxis instead of years, and the columns should represent the years. I tried rearranging the data array by replacing country names with years like this:
array(
array(
"name" => 2000,
"data" =>
array(
array("Bangladesh",27892),
array("Sri Lanka",10170)
)
),
array(
"name" => 2010,
"data" =>
array(
array("Bangladesh",56199),
array("Sri Lanka",12720)
)
)
);
After making these changes, the columns now appear correctly. However, the xAxis is showing "0" and "1" instead of "Bangladesh" and "Sri Lanka".
If anyone can provide me with a solution to fix this issue, I would greatly appreciate it. Thank you!