Hello,
i`m struggling to get this graph chart to work.

I have 3 related questions.

question 1:
why is the category name listed as $1 through $10 on the chart and
1 to 10 in the data series?
I want it listed as the names in column D.
question 2:
I would also like this chart on a new sheet within this work book.
question 3:
I`d like the chart to update as I add new rows to calculate into sheet 1
Screen Shot 2017-03-03 at 12.47.21 AM.png