Home > Books and Journal Articles > Data Visualization with Microsoft Excel > Interactive View > Multiple tables
Google
Web This Site

Excel Services Interactive View -- Multiple tables

Excel Services Interactive View introduced Microsoft's new capability of adding interactive view to any table on a web page.  Excel Services Interactive View -- Single table showed how to do so with a webpage containing a single table.  Here we see how to handle multiple tables on the same page.

For a single table, we added one 'a' tag and we also added a 'script' tag to the page.  Working with multiple tables is just as easy as working with a single table.  It turns out that each interactive view 'a' tag works with the table that follows it in the page layout.  And, of course, the required 'script' tag is added only once for the entire page.

Excel Interactive button 
Rank Nation Gold Silver Bronze Total
1 China (CHN) 29 16 14 59
2 United States (USA) 27 14 15 56
3 Great Britain (GBR) 16 10 10 36
4 South Korea (KOR) 10 4 7 21
5 France (FRA) 8 7 9 24
6 Germany (GER) 5 10 6 21
7 Italy (ITA) 5 5 3 13
8 Kazakhstan (KAZ) 5 0 0 5
9 North Korea (PRK) 4 0 1 5
10 Russia (RUS) 3 16 14 33

Table 1 -- Top medal contenders as of August 5, 2012
(ranked by gold medal count)

 

Excel Interactive button
Rank NOC Gold Silver Bronze Total
1 United States (USA) 46 29 29 104
2 China (CHN) 38 27 22 87
3 Great Britain (GBR) 29 17 19 65
4 Russia (RUS) 24 25 34 83
5 South Korea (KOR) 13 8 7 28
6 Germany (GER) 11 19 14 44
7 France (FRA) 11 11 12 34
8 Italy (ITA) 8 9 11 28
9 Hungary (HUN) 8 4 5 17
10 Australia (AUS) 7 16 12 35

Table 2 -- Top medal count at the end of the 2012 Olympics
(ranked by gold medal count)

 

Share your comments