The data I'm downloading has locations named by numbers, I've created a table/spreadsheet that has the name of each location and their corresponding numbers. I need to be able to create a pivot table or something that allows me to import the data and have excel to change the number data to name data for each location.
@j_tiller Not sure what your intentions are. You created a pivot table by name and number, summing the numbers. And, based on this pivot table you created a chart. What do these numbers represent? Are the values of some kind or just reference numbers?
Can you describe/explain how the table/graph you want should look like? Perhaps like in the picture below? If so, delete the Work Location Number from the Row field.