Westfield MC Market Data Charts

The towns I included by default are Clark, Cranford, Scotch Plains and Westfield. To view them, go to: Westfield MC Market Data

To add an additional towns or add to your website, follow the directions below.

Go to the Westfield MC Market Data spreadsheet on google drive.

Copy the spreadsheet to your google drive.

Make a copy of an existing sheet to be used for the new town by following these steps:

1. Click the down arrow next to the sheet name to open the sheet menu.
2. From the menu, select Duplicate.
3. A duplicate sheet (which contains the exact formatting) will appear in a new tab beside the original sheet. It's labeled Copy of Sheet.
4. Click the down arrow next to the sheet name  to Rename the new sheet.

Go to Terradatum.com to create a report. See figure 1.
Select View Your Report when finished. This will open a PDF.

Figure 1

On the PDF report, copy the text as shown in figure 2 for the top graph.

Figure 2

Paste the copied text into the one cell as shown in figure 3. 
This will auto populate the data and update the charts.

Figure 3

Next, copy the text as shown in figure 4 for all the lower graphs.

Figure 4

Paste the copied text into the one cell as shown in figure 5.
This will auto populate the data and update all the lower charts.

Figure 5

Now you can publish the page to the web. Once it is published, you can share the
charts as a webpage using a link or embed the individual graphs into a webpage into.

---

The individual charts can also be publish directly into a webpage.