1

I have an annoying problem about updating decimal separator in chart axis after changing the international settings, for example when switching from "." to ",". Decimal separator changes in cells normally, but it does not change in labels of a chart axis. Restarting excel solves the problem.

But is it really necessary to restart excel? I would be happy to do it without the restart, because I am creating an utility allowing other users to print under english or czech language settings and restarting the excel is unwanted here.

I found several discussions related to the topic, but it is not exactly what I need and I did not find a solution there (hope I did not miss anything), for example

Chart axis custom number format localization in Excel 2010
Excel chart won't update
Wrong decimal separator in charts

What is even more surprising is that if I create a whole new chart it also displays the original decimal separator, not the new one I set.

Thanks for any advice, p.

situation

Community
  • 1
  • 1
Pepacz
  • 881
  • 3
  • 9
  • 24
  • 1
    I didn't understand. The old chart does not update, ok. But the new chart, it keeps the same as the old or does it update? – Daniel Möller Jul 22 '13 at 12:11
  • 1
    also, if you have a picture that helps explain, you can put the link in, and a higher rep user may add the image for you – SeanC Jul 22 '13 at 12:19
  • I will try to write more clearly next time. I edited the question and added link to the picture. Both the charts have the original decimal separator, not the new one I set. – Pepacz Jul 22 '13 at 15:59
  • I know it's late.. but 1.2 is on your x-axis... you've changed your x value not the y-value, that's why the graph is not changing. – kpark Aug 22 '13 at 16:22
  • @kpark91 you are right, I overlooked that, now it should be ok. But as you can see, the problem still prevails. I have not found a solution yet. – Pepacz Aug 28 '13 at 07:04

0 Answers0