Show current evolution against expected historical variability and add one or more series that could account for the difference. Read More
Dylan Tallchief recreated “Take On Me” by a-ha in Excel. It’s not the tools. It’s how you use them. Something something blah blah. It’s in Excel! Tags: a-ha, Excel, songs
Also known as a bivariate area chart, the plot type focuses on the comparison between two time series. Read More
I’m just gonna put this right here, from @_daviant: “Another day another stupid Excel chart”. Tags: Excel, humor
Easily compare multiple categories and spot differences between two or more series. Read More
For Datawrapper, Lisa Charlotte Rost outlines the steps to prepare and clean your data in Excel or Google Spreadsheets. From the beginning: When you download an Excel file, it often has multiple sheets. Our data set has three of them, as seen on the bottom: “Data”, “Metadata – Countries” and “Metadata – Indicators”. Look through all of your sheets and make sure you understand what you’re seeing there. Do the...
Introducing yourself to R as an Excel user can be tricky, especially when you don’t have much programming experience. It requires that you switch from one mental model of the data that exists in an interactive spreadsheet to one that exists in vectors and lists. Steph de Silva provides a translation of these data structures for Excel users. Tags: Excel, R
Remember the artist Tatsuo Horiuchi who uses Microsoft Excel to paint scenery? Four years later, he’s still at it. Watch below. Horiuchi is my favorite example of someone who shows that the tool is secondary to what you want to make. Spend less time debating about what software you should use to visualize your data, and spend more time deciding what you want to show. Tags: Excel, paintings, tools
Government data isn’t always the easiest to use with computers. Maybe it’s in PDF format. Maybe you have to go through a roundabout interface. Maybe you have to manually request files through an email address that may or may not work. However, this file that OpenElections received might take the cake. It’s a spreadsheet, but the numbers are clipart. City of Detroit produced a lookup tables for its absentee precincts...
For Excel users getting started with R, pain oftentimes finds its way into the learning process. Gordon Shotwell feels your pain and provides a primer to shifting to a different approach to your data. At the beginning, when you are trying to accomplish simple things like balancing a budget or entering some data by hand, R is definitely harder to learn than Excel. However, as the task gets more complex,...