Archive for the ‘Data Visualization’ Category.
February 17, 2012, 12:16 pm by Tushar Mehta
A Radar Chart, also known as a Spider Chart, visually compares several entities (products, organizations, investment opportunities, or even people) on multiple dimensions. For example, a manager of a diagnostic imaging (radiology) center might want to compare her facility with the competition on dimensions related to patients such as Time To Appointment, Report Turnaround Time, No Show Rate, and Wait Time.
Or, one might want to compare 6 products A, B, C, D, E, and F on 6 different attributes: Aesthetic Appeal, Compatibility, Strength, Market Size, Durability, and Reliability. The Custom Radar Chart lets one easily compare all the products along each of the dimensions on interest. This is the example used in the documentation. With the axes normalized, the resulting chart would be
For more on this shareware product, please visit www.tushar-mehta.com/excel/software/custom_radar/index.htm
– Tushar Mehta
February 6, 2012, 2:49 pm by Tushar Mehta
Following up on my previous posts sharing my initial Excel mashups (http://www.dailydoseofexcel.com/archives/2012/01/29/excel-mashup-2/ and http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/), this post shares the details of how I created the second mashup. It assumes a basic familiarity with C-style syntax, asynchronous processing, and callback functions.
For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/data_visualization/15a%20Excel%20Mashup.shtml
Tushar Mehta
January 29, 2012, 2:46 pm by Tushar Mehta
Following up on the previous post (http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/) I extended the capability to create a Polar plot using a 2nd worksheet in the same workbook. The consumer provides graph parameters, including the graph type, using HTML form controls. The graph is in an Excel workbook.
Graph any Excel formula in a XY (Cartesian) chart or a Polar plot
January 25, 2012, 6:00 am by Tushar Mehta
Recently, Microsoft introduced a way to create a “mashup” using Excel. Fellow MVP, Jan Karel, put together a tutorial on how he created his first mashup. It helped me understand the basics, which are also well explained by Microsoft itself.
In my case, for a long, long time I have wanted to draw any graph on a web page and do so easily. Some years back Google introduced an API that I experimented with but it never caught my fancy.
So, here’s my attempt with JavaScript and MS Excel. Of course, Microsoft has a less than stellar history on web-based Excel/Office products (Office Web Components comes to mind). But, maybe, this time around it will be different, given the push that the company as a whole is making for web-centric products.
Graph any Excel formula as a function of a single variable
I will post a “how I did it” article in a day or two together with links to whatever documentation / samples I could find on the ‘Net.
December 15, 2011, 4:42 am by jkpieterse
Hi everyone!
As you may have seen on some blogs, Microsoft now enables you to include any Excel file -or parts thereof- in your web pages and blog posts.
For example (yes you can make changes to the cells, they are not retained):
I have written an article that explains how this is done.
Even more: I have also created a demo where you can enter information in a web form (a textbox), which in turn updates information in the embedded Excel web app file.
Enjoy the read: Embedding Excel files on your website
Regards,
Jan Karel Pieterse
www.jkp-ads.com
