Get in Touch

Reach out with any project requests or questions and comments about my work.

           

123 Street Avenue, City Town, 99999

(123) 555-6789

email@address.com

 

You can set your address, phone number, email and site description in the settings tab.
Link to read me page with more information.

Making of: Visualizing the Excel table data

Reads

A look at the process behind creating various visualizations and graphics.

Making of: Visualizing the Excel table data

Farruh Tillaev

Tools used: Pen/Paper, Spreadsheet, Vector illustration software

A client has requested some help with visualizing the table data. It is the collection of responses from the focus group, about the importance of brand values and brand statements, along with their performance.

Here's the data in it's glorious form. There are two main columns: Performance and Importance. Each column then is divided into sub-columns that include categories like age group, occupation, etc. We'll start by focusing on the two columns highlighted in yellow. 

data-table
 

To keep things simple, instead of creating one huge chart that includes all the information at once, we've agreed to create a chart for each category. This way, viewers can compare the trend across the age groups, occupations, and other categories.

Here's the chart in Excel:

excel scatter chart
 

Alright, looks like we have an initial idea on how to go ahead with this. Off to the sketchboard!

You can see some of the sketches of the process. The goal is to simplify the whole thing, and make sure copy is legible and it's easy to place each finding within the chart:

chart sketch 1
chart sketch 3
chart sketch 2
chart sketch 4
 

Hmm. Looks like the circular version of the chart communicates the information easier and cleaner than the rest. Here's the digital draft:

chart-draft
 

So far so good. Let's add some colour and details to finalize the graphic. 

data-chart