Numbers behind comma not visible

Hi there!

Im using a chart which displays numbers like this 6,547. I only get 6 visible. What can I do to get at least 2 digits (6,54)?

You need to provide numbers in your CSV without commas, because commas in the CSV are delimiters. So instead of entering 6,547 just enter 6547 in your CSV file. Then in a chart settings you need to set “Number Format” option to “#,###” and you will see 6,547 at a chart. Read about this solution in this thread.

Negative numbers are not visible: -0,546 is gone

What is the range (min and max values) of the data in your chart?

Hmmm…still no go. Have a look:
https://oi61.tinypic.com/16ll074.jpg

range is like this:
https://oi57.tinypic.com/2lihfvc.jpg

give me a link to your CSV file(s).

Here:
https://dl.dropboxusercontent.com/u/21390295/test.csv

Try to use following data for your CSV:

Month,2009,2010,2011,2012,2013,2014
string,number,number,number,number,number,number
Janu.,6698000,4845000,5560000,4491000,6050000,6975977
Febr.,5965000,6648000,7370000,7490000,6795000,
Mars,7530000,7266000,7756000,6590000,5988550,
Apri.,9769000,7515000,6300000,6010000,8230000,
Mai,6248000,5985000,7977000,6300000,7351288,
Juni,6873000,7186000,7290000,7120000,6934738,
Juli,3438000,3487000,3183000,1600000,3324522,
Augu.,6294000,6674000,7782000,5790000,6565288,
Sept.,8178000,7250000,7200000,6500000,9540000,
Okto.,7412000,7850000,6966000,6906000,7891439,
Nove.,7300000,9628000,7542000,6400000,8267000,
Dese.,7066000,8328000,7200000,6050000,7822429,

Some notes:

1. Add data type at the second line of the file. It has to be string and number in your case.
2. Do not add any spaces, commas or else characters to the number values

Let me know how it works.

Hmmm…I need to work in Google Spreadsheet or Excel with this. Can you send med a sample file?

https://dl.dropboxusercontent.com/u/61868050/test.csv

Thanks, but its still no good. It doesn’t show #,### correct
It was actually perfect how it was if it only could show #,###

https://dl.dropboxusercontent.com/u/21390295/new%20file%20test.png

You entered #,## instead of #,###. Recheck your options.

Still no go….

What about negative numbers they appear positive?

-619000 shows as 619000

Can you give me an access to your admin dashboard? Create an account for contact[at]madpixels[dot]net with editor role. I will look at it.

Sorry, but this is an intranet restricted with htaccess

hm… in this case i don’t know how to help you.

I just set up a test environment:

https://test.merkurtrykk-web.no
User: madpixel
Pasw: madpixelscharts

How do we get negative numbers to show as negative?

I have created a new chart at your site and looks like everything is working fine. Find it here.

I have used this file: https://dl.dropboxusercontent.com/u/61868050/test.csv

All negative values are shown correctly, all number formats are shown good. I have added #,### to each series on the chart.

Show me what doesn’t work for you? Give me a CSV file which doesn’t work for you.