Can you provide a sample packaged workbook that represents your situation? does not need to be real data, just data that is similar.
I had the exact same problem a couple of days ago.
I was going to make a packaged workbook to post, but this time I successfully got the numbers on the axis instead of names. My guess is you might find the same when you try it again.