Home Forums Chart Support dynamic multistacked graph

dynamic multistacked graph

Viewing 13 posts - 16 through 28 (of 28 total)
  • #23280

    https://canvasjs.com/php-charts/stacked-column-chart/
    I am referring this chart, I want the labels should come from database and it should plot the graph, according to that particular labels should display the status in the graph,how to apply loop for dynamic database data please help me
    Thank you

    #23281

    I am referring stacked-column chart, I want the labels should come from database and it should plot the graph, according to that particular labels should display the status in the graph,how to apply loop for dynamic database data please help me
    Thank you

    #23293

    Thank you @Vishwas R for solving my previous issue,hope you will solve my second issue also.
    Thank you

    • This reply was modified 5 years, 4 months ago by snehal.
    #23297

    @snehal,

    I want the labels should come from database and it should plot the graph, according to that particular labels should display the status in the graph,

    In multiseries charts, data-points are grouped based on common x-values. Providing same x-values along with labels should work fine in your case.

    The sample code provided in the previous reply seems to be working fine as per your requirements. If there are any changes in the code / database, please share the updated code that reproduces the issue you are facing, so that I can look into it and help you resolving it.


    Vishwas R
    Team CanvasJS

    #23300

    Thank You @Vishwas R.for your precious reply. I attached my requirements in this link please check it.
    https://drive.google.com/open?id=1F4oWopc5lxpsAjKcyOXyDTA64SyNv6T3
    Thank You

    #23306

    @snehal,

    You can modify SQL query to get the count of status and other parameters accordingly. Please take a look at this updated code where customers and status of the complaints are grouped based on userId – which is considered as x-value to the dataPoint (In multiseries charts, data-points are grouped based on common x-values).


    Vishwas R
    Team CanvasJS

    #23312

    Thank You sooooo much @Vishwas R. Hats Off to you :)

    #23313

    One more thing sir i want to ask, if we want to use customerName only instead of userid then how to modify it.Because if i Written customerName then blank graph is generating.
    Thank You

    #23314

    One more thing @Vishwas R. sir i want to ask, if we want to use customerName only instead of userid then how to modify it.Because if i Written customerName then blank graph is generating.
    Thank You

    #23326

    @snehal,

    If you don’t like to use userId and just use customerName from database, you need to parse data received from database accordingly. Here is the updated code for your scenario.


    Vishwas R
    Team CanvasJS

    #23327

    Thank you @Vishwas R. for solving my problem.

    #24967

    hello @Vishwas R sir, as u explained in above project how to fetch data for stacked graph it helped me,thank you. Now i want to know if “function” column in table will be dynamic means, if through master table another value is added in that column then how to handle it ??Please help me

    #24976

    @snehal,

    Please take a look at this sample project for creating dynamic charts using data from MySQL database in PHP. Also, please refer to this documentation page on creating a Live Updating Charts from JSON API & AJAX.


    Vishwas R
    Team CanvasJS

Viewing 13 posts - 16 through 28 (of 28 total)

You must be logged in to reply to this topic.