It can be done with your data in its current state (and I've attached a workbook that shows how), but it would be far easier to work with the data if it looked like the table below.
You might check out this thread for a discussion on the shape of the data: What to do if you have over 255 columns
and also, note that Tableau has an Excel plugin that allows Excel data to be easily reshaped so it can be more easily used in Tableau (find it here: Installing the Tableau Add-In for Reshaping Data in Excel | Tableau Software)
City Race Value Austin Asian 781 Austin Black 1821 Austin Hispanic 3827 Austin Other 42 Austin White 18380 Boston Asian 1128 Boston Black 3820 Boston Hispanic 4058 Boston Other 877 Boston White 28501 Charlotte Asian 131 Charlotte Black 2770 Charlotte Hispanic 1513 Charlotte Other 238 Charlotte White 38004
Reshaped.twbx.zip 23.9 KB
Thank you very much. I'd used the add-in but I suppose it kept the data in the same format. I'll dig in tomorrow AM. Thanks for your support
Wow! That's the first time I've had an answer marked correct while I was still editing it! (just making the table look nicer).
By the way, welcome to the forums!