-
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...
-
Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts. While none of...
-
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...
-
Ah, the great questions of life: Paper or plastic? Line chart or scatter chart? Choosing the wrong chart type for your data can easily happen when it comes to line and scatter charts. They look very similar, especially when a scatter chart is displayed with connecting lines, but there is a big difference...
-
A couple of weeks ago, as part of our Watch History Reimagined series, we posted a video to show you how Excel might've helped the team at NASA work through some of the tensest moments in American history. Some of you asked us how we created certain visualizations that appear in the video. In today's...
-
Have you ever wanted to add a horizontal or vertical line to your chart to indicate a key value, sales threshold, important date, or the average of your data? Are you looking to impress managers and convince clients with your superb charts? Reference Lines (see the dotted black line on the chart below...
-
In early May, we told you about the new video series Excel Skills Builder in our post " Take the first step in growing your Excel skills ." In that post, we announced the launch of lesson 1. Well, we've finally finished the rest of the lessons, and wanted to share this great resource with...
Posted to
The Excel Team Blog
by
Excel Blog
on
Tue, Jun 28 2011
Filed under:
Filed under: Charting, Conditional Formatting, PivotTables, Data Validation, Formatting & Printing, Solver, Excel 2010, Sparklines, Slicers, Beginner, functions, Excel Web Apps, PowerPivot, macros, Excel, training, Basics, Web Apps, SmartArt, print
-
A binary clock, or more accurately a binary-coded decimal clock, shows each digit in binary. I first saw one at a friend’s place and it served as an interesting ice breaker. The below image is from Excel. Specifically, it is an Excel chart, though most would be hard pressed to recognize it [...] Read...
-
The x-axis of a Column Chart can contains either category values (the x values are equidistant) or dates. Neither of these allows for a truly numeric x axis. This tip shows how to simulate a column chart that has cardinal numbers on the x axis (cardinal numbers contain a sense of ‘distance’ – [...] Read...
-
The x-axis of a Column chart can contains either category values (the x values are equidistant) or dates. Neither of these allows for a truly numeric x axis. This tip shows how to simulate a column chart that has cardinal numbers on the x axis (cardinal numbers contain a sense of ‘distance’ – [...] Read...
-
Data Driven Twitter Sparkline Generator
The app that everyone’s been waiting for. After months (20 minutes) of coding and Q&A, Data Driven is proud to release Sparkbars! In Twitter! v2.0 You may need to right click and save as an xls to stop the .zip being added. As Twitter now accepts Unicode,...
-
Tornado diagrams graphically display the result of single-factor sensitivity analysis. This lets one evaluate the risk associated with the uncertainty in each of the variables that affect the outcome. Single-factor analysis means that we measure the effect on the outcome of each factor, one at a time...
-
TM Chart Leader Lines simplifies the management of leader lines in a chart. This add-in, which works only with Excel 2007 or later versions of Excel, allows the easy interactive arrangement of data labels and their associated leader lines. What should not come as a surprise to anyone who has worked closely...
-
Sparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtime events in only four of twelve months. Here's...
-
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/xl_vba_cases/13-03%20Shapes%20on%20a%20Map.shtml Tushar Mehta Read More...