Google Chart Api

Discussion in 'Google API' started by X-inter, Dec 30, 2009.

  1. #1
    Hi everyone,

    I'm busy with a project where I need to show all data points between two given dates. startDate / endDate.

    The y-axis stands for %
    The x-axis for the days (yes I need a data per day view...)

    I've worked this out so far, but when I want to see more thant 2 years it won't give me the image... is there a limit for how much datapoints you can get?

    And what would be a wise thing to do with the x-axis labels? (I thought it would be nice to show the day numbers(5, 10, 15, 20, 30|31) with under every start of a new month the month name and with the start of a year the year number under the months.

    working example: (I can't post urls yet :( )
     
    X-inter, Dec 30, 2009 IP
  2. bsfweb

    bsfweb Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2

    Sounds good.
    The only thing I can add is to suggest the percentages contain values (or reference to values that make up the percentage). Have I explained myself clearly enough?

    e.g. if showing data relating to sales volumes: 33% (12,950) etc.
     
    bsfweb, Dec 31, 2009 IP
  3. X-inter

    X-inter Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for your feedback :) I will keep that in mind. But it is not really the answer to my question... My problem is that the url is getting very long... is there a limit for the api and if so... is there a API alternative? ( I tried JPGraph, but that one doesn't support x,y graphs....)
     
    X-inter, Jan 5, 2010 IP
  4. QiSoftware

    QiSoftware Well-Known Member

    Messages:
    805
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    158
    #4
    I've not worked with the Google Chart API-- but feel I should too offer clients this service. MS Access has a great charting ability... MS Graph and those quick data interpretations can be useful. A picture is often worth a thousand words.

    Can you decrease the number of period lengths within the 2 year max time range to decrease the amount of data that must be returned?

    Q...
     
    QiSoftware, Jan 20, 2010 IP
  5. X-inter

    X-inter Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Well I found out that the Google Chart API wasn't good enough for me but I found another one from google which had all the options I needed (+ you can decrease the period length with a cool slider function). The name of tis API is Google Visualisation API.

    Take a look at: http : // code.google. com/intl/nl/apis/visualization/documentation/gallery/annotatedtimeline.html
    (I still cant paste links thats why the link is a little messy... just copy paste en remove spaces ;))

    for the example I used :)

    Case Closed :p
     
    X-inter, Jan 20, 2010 IP
  6. rrajkumar

    rrajkumar Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I too use Visualization API for my app. The problem is some times, the JS make take a lot more time to load and charts will not show up if javascript is disabled. Chart API will work even without javascript.

    You can make it an option to use something like noscript and use which ever mode is appropriate, based on the client browser and the amount of data.
     
    rrajkumar, Mar 13, 2010 IP
  7. khongwir

    khongwir Peon

    Messages:
    266
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Have you used tables for charts. There is a Google api which converts a tabular data into a chart automatically.
     
    khongwir, Mar 15, 2010 IP
  8. rrajkumar

    rrajkumar Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Yes, you can give the data in added to a DataTable object and then use the data to construct the chart.

    I have used bar charts (horizontal and vertical) and pie charts using this API.
     
    rrajkumar, Mar 15, 2010 IP