Keep a Contact List in a Doc Updated Using Google Sheets

The other day, I was reading our Teacher Handbook. The Teacher Handbook includes names of teachers and what they teach. The problem is that one teacher had changed positions and so the handbook was out of date.

This video shows how to keep documents updated by maintaining a single spreadsheet.

Chart Experiment - Retirement-Age Workers by U.S. State

I was pretty sure that I did this before, but looking back in my Google Drive, I don't see it. I thought that over the summer I had seen an article about states and their corresponding party affiliations and from that I made a chart. 

But I can't find it.

So, I grabbed data from 270towin for the political parties. 

Then I put it all into a Sheet and tried a few charts. I ended up deciding the bar chart showed it the best, although the radar chart was the most artistic.

So, then here's what 

This was still hard to gain evidence from, so I though maybe getting the sum would show me something. To me it looked like the blue states had a higher percentage. So, here are the SUM values.

Red 440.4

Purple 318.8

Blue 412.7

The count of each party are as follows:

D	16
P	14
R	20

The bar-thinckness couldn't be changed, and while I was trying different chart types, I tried the stacked bar chart. For some reason that made the bars wider.

Still, I am not thrilled with the lack of options for this type of data in Google Sheets.

The important things to remember with different series is how to structure the data. Each series needs to be in a different column.

Mapped: Retirement-Age Workers by U.S. State

Add a Label to Chart Data

I created a chart from some data. Gridlines would definitely help to make it easier to read, but a label would be even better. 

To add a label, go into the chart editor and click on Customize in the top menu. Then scroll down to Series. In the Series menu towards the bottom are three checkboxes - the last one is Data labels. You might need to change the format. 

Click on the drop down menu and select from source data.