Tuesday, May 12, 2009

Finished - Radar Chart Google Spreadsheet Gadget, That Is!

I believe I have finished the work on creating a Radar Chart Google Spreadsheet Gadget. Here are the changes since my previous release:
  • Added the ability to toggle individual records on and off in the chart. This allows better visual comparison between different records and/or the overall average.
  • Added the ability to toggle the competency line on and off. Also, if user does not input a competency value, the line would not be shown at all.
  • Added better error handling when any of the user inputs, spreadsheet data is not a number.
  • Added a process to determine the real maximum value for scales in radar chart.
  • Fixed the alignment problems of labels with various number of radar lines (columns).
  • Changed the gadget size to have a default height of 250px so it renders properly in iGoogle.
  • Changed the gadget size to use dynamic height for large records set.
  • Added a user configurable refresh time for the gadget, and default is 5 minutes.
  • If "Calculate average" is chosen, then the gadget will draw the radar chart of the overall average by default. Otherwise, it will draw the radar chart of all records.
  • Added a comment field.
This is what the current release looks like:


You can use this gadget with your own spreadsheet data. Here is how:
You can give me feedback via the comments section.

If it looks good, I will submit it to the Google Gadget Gallery in a couple of weeks.

4 comments:

BIM06 said...

I just want to say "Thanks" for this great gadget.

Greetings from Germany,

Daniel

Corinna said...

Thanks, Daniel. I'm interested to see how people are using it to visualize their data.

Would you mind publishing your radar chart, sharing it back here?

Mr. Anderson said...

Haven't read up on who you are or where you're from, but I will, and THANKS for a GREAT TOOL!

Our school uses Deming's Quality Management processes to improve student and classroom performance, and this radar chart is just what I needed to add to my classroom blog.
Thanks!

Evan Anderson
Voyager Charter School
Honolulu, HI

pmcdonnell said...

Corinna: I sent a comment earlier about your radar chart, but I can't find the comment string. I would like to apply your chart to an InfoPath form saved in a SharePoint library, essentially running the radar chart using a data source that is not a Google spreadsheet but is a SharePoint spreadsheet in our internal library. I am not a developer and so am not capable of modifying the XML or the Google API to run the chart against an inhouse data source. If you could help with this, I would be glad to pay for the help. My IT staff could surely figure it out, but they would be starting from a complete lack of knowledge about your code (and, even, about XML, which we do no use much). If you are interested please communicate with me directly at pmcdonnell@children.org. Thanks.