Chart and Data Formatting Differ

Hi,

I'm in america, but need to put together a file for germany so i'm going by their comma/decimal rules for numbers

So i went to Options, Advanced, and changed the separators, so not it accepts that number format
However, when i create a chart with the data, the chart is still in the american number formation

How can I fix for that the formatting of the numbers in the chart are the same as those in the data?
Thank you!!! )

-kb