Thread: Alter Chart Axis Label Number Format According to Language Selection

Hi there,

I have created a chart template tool that creates a chart using information speicified by a user. The tool can create a chart displaying either English or French information. I'm having trouble accomodating the display of French numeric formatting (i.e., # ##0,00) in the tool via the enabling/disabling of the "System Separators" properties of MS Excel 2007. When in MS Excel 2003, it works fine. I know that the charting mechanism in MS 2007 was redesigned.

Has anyone come across a similar problem? Was a solution found? If not, does that mean that I will have to programmatically alter the PC's regional settings to accomplish the desired language-specific numeric formatting?

Thank you.

Basically, I've used the same code for 2007 has I had done for 2003:

If gstrLanguageChoice = "_en" Then

English Numeric Formatting (i.e., #,##0.00)
-----------------------------------------
With Application
.UseSystemSeparators = False
.DecimalSeparator = "."
.ThousandSeparator = ","
End With

Else

French Numeric Formatting (i.e., # ##0,00)
-----------------------------------------
With Application
.UseSystemSeparators = False
.DecimalSeparator = ","
.ThousandSeparator = " "
End With

End If

Yes, it was a spelling mistake in the code that I had posted.

So my code did work for you in altering the numeric format of the chart axis labels? I should have added that the code did change the numeric formatting of data in the worksheet, but it was not reflected in the chart axis labels themselves.

If it also changed the formatting of the chart axis labels for you, I will have to ask the client how they configured xl2007 for their environment.

Thanks.

Yes. The format settings I have for my Y axes labels is that they are linked to the source data.

How is your xl2007 SP2 set up? I wanted to test it out on my work laptop (I have been using my client's desktop for development and unit testing of the tool), but I remembered that I had downloaded a trial version of xl2007 a couple months back and the trial period has elapsed.

Hi Andy,

I loaded MS Office 2007 (Home and Student ed.) onto my work laptop and applied the necessary updates/fixes/patches to duplicate your settings. However, I am still unable to display the proper Y-axis label formatting in my chart. Is there a system setting I should change?