Make sure you have installed Helvetica Neue.
- Load the provided Tableau table.
- The link to the worksheet will be broken. Feed it your new worksheet for SL or Liberia
- If your column names stay the same then the worksheet SHOULD load smoothly.
- Double-check to be sure and fix any obvious errors.
- Go to Print, and under the print menu Save as PDF.
- The file should export successfully as one chart per page.
- Load the exported PDF. You will have to select one of the pages from the PDF and only edit that one.
- Ctrl-A, Ctrl-alt-7 to release all clipping masks. Delete them.
- Delete all extraneous lines, boxes, etc. Use the provided previous round of charts as models
- Change all data colors to #F28964
- Change all NULL values to #807F7F (use this grey for other objects too)
- Resize any text to the values in the previous round of charts.
- Copy-paste across the title from the previous round of charts. Left-align it.
- Insert a grey "assessment" label in the appropriate place.
- Horizontal bar charts: Resize the left text to 10, right align, center on the bars
- Insert .5 thickness #D7D7D7 grey lines behind the bars / lines at appropriate distances. (Just choose what looks good - I aimed for one every third / quarter)
- Do any other fiddliness to get the chart looking like the old models.
- You're done! Repeat for the other charts.
Once I broke this down to a process it was fairly rote. I found that programming some AI Actions sped up the text alignment stuff.