See answers inline:

On Tue, Sep 7, 2010 at 1:19 AM, akgupta01 <[email protected]> wrote:

> Hi there,
>
> For my group, I am creating an internal Google site and would like to
> embed an org chart similar [http://www.freeorgchart.com] within Who's
> who page.
>
> Some additional features:
>
> To make it easier, I would like to store the rawdata in
> GoogleDocspreadsheet in a tabular format and access this data in
> GoogleVisualization API to create an orgchart
>


> So now questions:
> * How to access the data from GoogleDoc Spreadsheet
>

http://code.google.com/apis/visualization/documentation/spreadsheets.html
 <http://code.google.com/apis/visualization/documentation/spreadsheets.html>


> * Can I include the resulting code into Googlesite HTML[cut-n-paste].
> I tried but got a warning about script.
>

No problem the API can go on any webpage
http://code.google.com/apis/visualization/documentation/gallery/orgchart.html#Example


* Include photo of each employee in the OrgChart and where to store
> the images
>

you can include any html snippet you like as the orgchart nodes.
You would have to store the images yourself.


> * When Mouseover, it shows a text which contains the short bio
>

add a handler to your html snippets. (onmousehover)


> * Use Search tools to find a specific person or if I click on a person
> it shows this info in a nice concise way [more like an anchor on the
> html page]
>

you'll need to implement this yourself on the data table and then highlight
the related node.


> * Be able to collapse different levels
>

just click nodes in the orgchart


> I have gone through multiple help docs but didn't see a concise
> example of combining different features.
>

HTH
ChartMan




>
> Will really appreciate any pointers.
>
> Thank you,
> Ashwini Kumar
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Visualization API" group.
> To post to this group, send email to
> [email protected].
> To unsubscribe from this group, send email to
> [email protected]<google-visualization-api%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-visualization-api?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Reply via email to