It is difficult to see what you are doing based on a picture. It would be more helpful to upload a small sample file.

Question 1: It is difficult to say from a picture. My first guess is that you have not assigned a range to the horizontal/category axis data for the pie chart. The first thing I would do is to open the Select Data dialog and see what range/values are assigned to the horizontal category axis field. If it is not column D, then Edit this range so that it is pointing to column D.

Question 2: I think these instructions should still apply to 2011, or something very similar: https://support.office.com/en-us/art...1-1d0788ea783f

Question 3: Some say that this is an advantage to "formatting" your source range as a data table. I rarely have cause to use data tables in my work, so I would use a dynamic named range for this http://peltiertech.com/dynamic-charts/