Is this a chart created in Word or is it in Excel? You generally have better control in Excel so that I where I would be creating it.

Maybe you should post a file containing the chart so we can see what your data range contains

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia