webchart question

  • fatwalletguy 3 years, 4 months ago

    I did try to follow this example but it is in vb.net
    also i want a bar chart but just one bar which shows two different colors

    for eg

    http://our.componentone.com/2011/04/28/chartinreport-c/

    Sales – Table

    salesid , salesperson, Productid, product, Goalpermonth goalperquarter achievedgoalpermonth achievedgoalperquarter

    1 Jon 1 TV 100 300 15 200
    2 jane 1 TV 50 100 25 90
    3 Jon 2 radio 100 300 15 200
    4 jane 2 radio 50 100 25 90

    my page should have a dropdown with two values ( jon , jane)

    once jon is selected then my bar chart should be show product tv on Y axis then 1 bar chart with goalpermonth value in grey and achievedgoalpermonth in green
    and as he nears his goal of hundred thegrey part should decrease and the green part should increase

    tv |—–GREY——–_______GREEN____
    |
    |
    |
    |
    |
    Fridge |———____________
    JON

    IF jANE IS SELECTED FROM DROPDOWN THEN BAR CHART SHOULD LOOK LIKE THIS

    tv |—–GREY——–_______GREEN____
    |
    |
    |
    |
    |
    Fridge |———____________

    JANe

  • 44p
    Ashish Jindal44p 3 years, 4 months ago

    Hello,

    It seems that you have found the answer yourself as mentioned in the following link : http://our.componentone.com/groups/asp-net/studio-for-asp-net/forum/topic/webchart-barchart-overlapping/

    If you want to stack the data then you may set the Stacked property of the ChartGroup to true. For more information on same, you may refer to this link : http://helpcentral.componentone.com/nethelp/c1webchart2d/default.htm?turl=XMLDocuments%2FC1Chart2DReference%2Fhtml%2FP_C1_Win_C1Chart_ChartGroup_Stacked.htm

    Let me know if you have any other questions.

    Regards
    Ashish

  • fatwalletguy 3 years, 4 months ago

    yes I can use stacked webchart for showing what i want, my question is
    if I have two pairs of value , it shows it in one bar chart with 4 colors combination
    but i want it to show two stacked barchart next to each other how do i do it

    tv |—–GREY——–_______GREEN____ 1 month (1st stacked bar chart)
    tv|—–BLUE—–__________RED_____ 3 month (2nd stacked bar chart)

    as of now it gives me

    tv |—–GREY——–_______GREEN____———–BLUE___________RED_____ ( just one chart ) instead of two , yes i can show regular bar chart with 1 next to another but i have to show it for 10 people and that means i have will have to deal with 20 bars which do not fit into the area

    series 0
    series 1
    series 2
    series 3

    but i want
    series 0 series 0
    series 1 series 1

  • fatwalletguy 3 years, 4 months ago

    Also please let me know how i can use 1 on 1 corresponding to x and y coordinates mapping from a table X , X1 , Y, Y1

  • 44p
    Ashish Jindal44p 3 years, 4 months ago

    Hello,

    I am not clear about your requirement since in a stacked bar chart, different dataseries are displayed as one on top the other like
    series 3
    series 2
    series 1
    series 0

    So, I would request you to send a small sample replicating the issue so that I can check and can provide you further assistance. Also, if possible, send the screen shot of output which you are getting and the desired output.

    Regarding your other query, you need to set the DataField properties of X and Y objects of dataseries and you may refer to the below link for more details : http://helpcentral.componentone.com/nethelp/c1webchart2d/default.htm?turl=databinding.htm

    Regards
    Ashish

  • fatwalletguy 3 years, 4 months ago

    hi Ashish,

    Please find attached data and reqirements in sheet one and screenshot in sheet 2
    Thanks

    Attachments:
    1. SQTable.xlsx
  • 44p
    Ashish Jindal44p 3 years, 4 months ago

    Hello,

    I have created a sample implementing your requirement of having one bar chart caseGoal /Case Actual and other for AcctGoal/AcctActual. I have bind the chart with your datatable and plotted two dataseries : one for CaseGoal and other for CaseActual against the SQName on x-axis. Kindly check the attached sample("barChart") and let me know your observations.

    Regarding your other query i.e customize text in tooltip, I have escalated it to the concerned team(TFS ID:16327) and would update you as soon as I hear anything from them.

    Regards
    Ashish

    Attachments:
    1. BarChart.zip
  • fatwalletguy 3 years, 4 months ago

    Ashish

    if you look at the demo in the link below

    http://demo.componentone.com/ASPNET/AdventureWorks/Products.aspx?Category=Bikes&SubCategory=Road%20Bikes

    if I hover on the bike , it shows a ballon or tool tip dont know what that is , I want the same functionality and if you click on the bike image it takes you the detail page and left hand side it has a small graph which shows percentage which are dynamic

    Thanks

  • 58p
    richas58p 3 years, 3 months ago

    Hello,

    We have received a reply from the developer. The customized tooltips are not shown due to the implementing problem. It needs 3 correct number of points for a circle, instead of 2.
    The developer gave a workaround to view the customized tooltips. Please refer to the attached sample for more clarity.

    Let me know in case you have further queries.

    Thanks,
    Richa

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.