From the course: Infographics: Planning and Wireframing

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Organizing your data in a spreadsheet

Organizing your data in a spreadsheet - Photoshop Tutorial

From the course: Infographics: Planning and Wireframing

Start my 1-month free trial

Organizing your data in a spreadsheet

Sometimes the data you'll collect for an infographic is straightforward, or even sparse, but often you'll be sitting on a mountain of information. I prefer to put all of my data into spreadsheets, so I can easily sort it, and look for stories within it. You'll also use spreadsheets for calculating formulas for the size and placement of elements you might be comparing in, for example, an area bubble chart, which we'll do in another lesson. In this video, I just want to walk through how I like to organize my data, so it can be easily sorted, and referred to while I'm illustrating. As you can see here, we've opened Microsoft Excel, and I've started creating a spreadsheet for our data. I've already filled in a few things, which I'll explain, and then we'll work on filling in some together. The first sheet I like to create is a summary of the different sections of the infographic, or of the different sets of data. I have a row for each section, with a column where I indicate if this…

Contents