• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Turning my spreadsheet into a graph

Steve Strom

Steve Strom

New Member
Hello friends,

This is my first post. I work in state government and am looking for some opportunities to present the data that we use at our board meetings in a more graphic format that makes it easier to understand.

I have been perusing the site today and found a thread about creating a pie of a pie graph which is pretty close to what I'm looking to do with my data. I also found a youtube demo of a cloud based product called Scitivate that works with social media data to create graphs based on demographic information. I've included a screen capture of their graph and included it with my spreadsheet to see if anyone else has created a similar graph or if there's already one on the site and I just haven't found it yet.

The spreadsheet contains a list of current projects that I would like to group either by committee assignment or project manager. The first level of the graphic would show the 5-6 circles with the count of individual projects assigned to the committee or the project manager. When a user clicks on one of the circles (or other icon), the graph would open to show the list of projects. A user could then click on the name of any project to get further detail on the project - begin/end date, funded amount, how much expended so far, etc.

I hope I have provided enough information to make my request understandable. If not, please reply for clarification.

Thanks in advance for your assistance.

Steve
USA


Post Moved by Mod
 

Attachments

  • Grant Worksheet for Steve.xlsx
    109.2 KB · Views: 16
Last edited by a moderator:
Or you can build it yourself
Code: 
<html>
<body>
 <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

<div id="sankey_multiple" style="width: 900px; height: 300px;"></div>

<script type="text/javascript">
  google.charts.load("current", {packages:["sankey"]});
  google.charts.setOnLoadCallback(drawChart);
   function drawChart() {
    var data = new google.visualization.DataTable();
    data.addColumn('string', 'From');
    data.addColumn('string', 'To');
    data.addColumn('number', 'Weight');
    data.addRows([
       [ 'GRANT FUND', 'FINANCIAL ASSET DEVELOPMENT', 325000 ],
       [ 'GRANT FUND', 'COMMUNITY LIVING', 335920 ],
       [ 'GRANT FUND', 'ADVOCACY DEVELOPMENT', 735000 ],
       [ 'GRANT FUND', 'CROSS CUTTING', 677773.71 ],
       [ 'GRANT FUND', 'ADMINISTRATION', 550000 ],
     
      ['FINANCIAL ASSET DEVELOPMENT', 'PROJECT SEARCH', 100000 ],
      ['FINANCIAL ASSET DEVELOPMENT', 'UPWARD FINANCIAL STABILITY', 75000 ],
      ['FINANCIAL ASSET DEVELOPMENT', 'LEARNING & EARNING AFTER HIGH SCHOOL', 150000 ],
       
        ['COMMUNITY LIVING', 'SAFETY AND SECURITY: DOMESTIC VIOLENCE', 50000],
        ['COMMUNITY LIVING', 'GUARDIANSHIP', 75000 ],
        ['COMMUNITY LIVING', 'MEDICAL & HEALTH HOMES', 105920],
        ['COMMUNITY LIVING', 'EMERGENCY PREPAREDNESS', 105000],
       
        ['ADVOCACY DEVELOPMENT', 'PARTNERS IN POLICYMAKING', 185000],
        ['ADVOCACY DEVELOPMENT', 'NC ADA NETWORK - FISCAL AGENT/INTER.', 40000 ],
        ['ADVOCACY DEVELOPMENT', 'NC CHAPTER OF THE NCADSP', 100000],
        ['ADVOCACY DEVELOPMENT', 'SIBLING SUPPORT', 50000],
        ['ADVOCACY DEVELOPMENT', 'NC ADA NETWORK', 60000],
        ['ADVOCACY DEVELOPMENT', 'MEDICAL REFORM SEG', 100000],
        ['ADVOCACY DEVELOPMENT', 'ADVANCING STRONG LEADERS', 200000],
       
        ['CROSS CUTTING', 'CONFERENCE FUNDING', 24000],
        ['CROSS CUTTING', 'COUNCIL DEVELOPMENT INITIATIVE', 40000],
        ['CROSS CUTTING', 'JEAN WOLFF-ROSSI FUND', 30000],
        ['CROSS CUTTING', 'PROGRAM MANAGEMENT/QM', 388773.71],
        ['CROSS CUTTING', 'PUBLIC POLICY', 60000],
        ['CROSS CUTTING', 'NCCDD COMMUNICATIONS', 135000],       
   
        ['ADMINISTRATION', 'ADMIN. STAFF & COUNCIL EXPENSES', 550000],             
     
        ]);

    // Set chart options
    var options = {
      width: 1800,
     height: 800,
     sankey: { node: { nodePadding: 20} },
     sankey: { node: { width: 5 } }
    };

   
    // Instantiate and draw our chart, passing in some options.
    var chart = new google.visualization.Sankey(document.getElementById('sankey_multiple'));
    chart.draw(data, options);
   }
</script>
</body>
</html>
 
You must log in or register to reply here.
Back
Top