I need to create Organizational Chart for a company website which is a Google Site.
I found the Google Visualization Organizational Charts ( https://developers.google.com/chart/interactive/docs/gallery/orgchart) fine for this task, understand how the nodes are rendered base on data table but since I have no JavaScript experience, I found no way to embed such script (as Google App) into this Google Site. It works fine on any external site or as a standalone .html, but not on a site by Google:) So instead of embedding the JavaScript, I created a Spreadsheet as data source and inserted Organizatonal Chart rendered from this data. all fine until this moment, see attached: <https://lh5.googleusercontent.com/--elJr_Ch4nk/UkQVGHooAdI/AAAAAAAAAEE/Ir4qoH3l6jc/s1600/source_sheet_not_styled.png> <https://lh4.googleusercontent.com/-5DzaHraVBEg/UkQVKHAHydI/AAAAAAAAAEM/L8Z17DWrAD0/s1600/org_chart_not_styled.png> Now I want to change some chart styles like: different background color for nodes, font size etc. I tried placing whole example code from https://developers.google.com/chart/interactive/docs/gallery/orgchart in A1 cell, but the chart treats it as text. See: *Is there a way to add some custom styling to Org Chart nodes if it's rendered from a Spreadsheet?* Maybe some data format in the Spreadsheet itself is needed? It would be best form me to have the Chart rendering simply recognize HTML/CSS tags entered in the Source Spreadsheet. I know HTML and CSS quite well. <https://lh5.googleusercontent.com/-fSwONS2KppY/UkQVPyNdCMI/AAAAAAAAAEU/tOXaYjFVEss/s1600/source_sheet_styled.png> <https://lh4.googleusercontent.com/-s_wAQOZPDqo/UkQVWMCHtII/AAAAAAAAAEc/UAi89aA4Cck/s1600/org_chart_styled.png> Or maybe you can point at a guide showing a non-JS user like me a way to place a Google Orgaizational Chart in a Google Site, step-by step. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
