Custom Variables BAO

[djcrouse]

I am trying to customize the "Language Spoken at Home" chart. I need to combine the age groups (5-17, 18-64, 65+) by specific language categories. When I try to do an advanced custom variable, the language variables are not available. Is there a way to do this? I manually did an Excel with the data from the reports for each designated site, but then I don't know how to put the Excel chart back in the template. And I would rather the template run it and put it in a chart that matches the rest of the template. 

Attached is the Excel with the data and chart.

Thanks!

[HelenThompson · Accepted solution]

Hi

Data from ACS - the language variables you are using - has a margin of error associated with it. Any data where there are MOEs, is not available for custom variables because we have concerns about combining them into a single variable.

[djcrouse]

Thank you!