nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

separator decimal

XFabien

Hello,

I have a question. I want to change the separator decimal to dot '.' not comma ',' in the axe of my chart,like the image below. I have change the cells to format 'fixed' and location 'english' in the table which contain the chart. But it can't work for the axe of the chart.

Find more posts tagged with

Comments

mwilliams

Can you go to the y-axis section of the chart and choose to format the label there?

XFabien

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80393" data-time="1311264635" data-date="21 July 2011 - 09:10 AM">
Can you go to the y-axis section of the chart and choose to format the label there? </blockquote>
 
Hello Michael, 
 
I had tried this, but it didnt work. It why that I ask the question here, seems that a little silly. :unsure:

mwilliams

Hmm. Well, if replacing the ',' with a '.' is all you need, you can replace the ',' with a ',' in your chart script with something like: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
function beforeDrawAxisLabel( axis, label, icsc )
{
label.getCaption().setValue(label.getCaption().getValue().replace(",","."))
}
</pre>

XFabien

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80416" data-time="1311279624" data-date="21 July 2011 - 01:20 PM">
Hmm. Well, if replacing the ',' with a '.' is all you need, you can replace the ',' with a ',' in your chart script with something like: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
function beforeDrawAxisLabel( axis, label, icsc )
{
label.getCaption().setValue(label.getCaption().getValue().replace(",","."))
}
</pre></blockquote>
 
 
Thanks Michael. It work well with this.