Create line graph in Excel, Illustrator and Tableau [~2 hours]
- Due Oct 14, 2014 by 10am
- Points 4
- Submitting a file upload
This assignment will introduce you to using Excel, Illustrator and Tableau for data displays. You will create a line chart of the data shown below in this (slightly modified) chart from the PEW Research Center.
STEP 1: Create a new Illustrator file and paste in a copy of the image above.
STEP 2: Download the data for this chart here.
STEP 3: Create the line chart with Illustrator (the video below shows you how)
STEP 4: Create the line chart with Excel (the videos below show you how—watch the one that is appropriate for the operating system you're using)
Video showing how to create a line chart in Excel 2011 (for Mac):
Video showing how to create a line chart in Excel 2013 (for PC):
STEP 5: Paste your Excel chart into Illustrator in preparation for formatting it (something you'll do in the next assignment). There are a few tricks involved in doing this. Watch this video to learn them:
Working with charts pasted from Excel:
STEP 6: Create the line chart with Tableau (the video below shows you how). If you're using Windows, watch both. If you're using a Mac, just watch the first.
Video showing how to create a line chart in Tableau for Mac (very similar to Windows, the exception being that what you see when you connect to a data source looks a little different. The video below shows that): this is a media comment
Video showing how to connect to data in the Windows version:
STEP 7: Save your Tableau chart to a pdf file, then open it in Illustrator and paste it into your Illustrator file. (Watch the appropriate video for your operating system).
This video shows you how (for the Windows version of Tableau)
This video shows you how (for the Mac version of Tableau)
STEP 8: Save a copy of this illustrator file to use for the next assignment.
UPLOAD: A pdf file with your three line charts