# Worksheet as a chart – multiple conditional formats

Several years back, I wrote an article on how to use multiple cells to simulate conditional formats that involved more than 3 conditions. Three versions of Excel later, I still receive requests related to this post. So, I updated it to include more screenshots and a downloadable file. In Excel 2003 and earlier, conditional formatting …

Continue reading ‘Worksheet as a chart – multiple conditional formats’ »

# Excel Services Interactive View

Analyze data with Excel on the web Microsoft has introduced a new web based capability that extends its Excel Services offering.  This new capability provides a limited interactive view of any table in a web page. An introduction to this service is below.  For those interested in additional capabilities and more advanced and useful capabilities …

Continue reading ‘Excel Services Interactive View’ »

# Use an Excel chart to show a time snapshot and trace a path

These Excel charts were inspired by Hans Roslingâ€™s TED presentation on Religion and Babies (http://www.ted.com/talks/hans_rosling_religions_and_babies.html). He is absolutely great at engaging the viewer with his ability to bring data to life. One of the things he did in his presentation was show the equivalent of an Excel bubble chart. He showed how different countries measured …

Continue reading ‘Use an Excel chart to show a time snapshot and trace a path’ »

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, …

# Excel Mashup #2

Following up on the previous post (http://tmehta.com/tmblog/?p=359) 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 …

Continue reading ‘Excel Mashup #2’ »

# Geocoding with Excel and VBA

Before one can position an address (a street address or a town itself) on a map, it must be converted to geographic coordinates (latitude and longitude). Then, that latitude and longitude is mapped to a particular location on the map. Figure 1 shows several thousand U.S. cities and towns on a Mercator projection map. Well, …

Continue reading ‘Geocoding with Excel and VBA’ »

# Winning Designs

A contest judged by a group from mrexcel.com and Microsoft focused on visualizing data in Excel with PowerPivot where the data came from the Azure cloud data service. The details are at http://www.mrexcel.com/Challenge2011/challenge_52011.html. I won one of the 2 prizes based on my three contest submissions (http://www.mrexcel.com/Challenge2011/challenge_52011_win.html). This post summarizes the three entries. My plan …