WordPress.org

Ready to get started?Download WordPress

Forums

Visualizer
Numbers behind comma not visible (19 posts)

  1. larsgj
    Member
    Posted 6 months ago #

    Hi,

    I had so much trouble with publishing and embedding from Google so this plugin saves my day. Thanks!
    Now two problems I got:

    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)?

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

    Thanks!

    https://wordpress.org/plugins/visualizer/

  2. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

    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?

  3. larsgj
    Member
    Posted 6 months ago #

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

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

  4. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

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

  5. larsgj
    Member
    Posted 6 months ago #

  6. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

    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.

  7. larsgj
    Member
    Posted 6 months ago #

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

  8. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

  9. larsgj
    Member
    Posted 6 months ago #

    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

  10. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

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

  11. larsgj
    Member
    Posted 6 months ago #

    Still no go….

    What about negative numbers they appear positive?

    -619000 shows as 619000

  12. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

    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.

  13. larsgj
    Member
    Posted 6 months ago #

    Sorry, but this is an intranet restricted with htaccess

  14. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

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

  15. larsgj
    Member
    Posted 6 months ago #

    I just set up a test environment:

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

    How do we get negative numbers to show as negative?

  16. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

    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.

  17. larsgj
    Member
    Posted 6 months ago #

    Can I ask what the difference in the .csv are?
    https://dl.dropboxusercontent.com/u/21390295/negative%202013.csv

  18. larsgj
    Member
    Posted 6 months ago #

    Sorry..

    This is the files I need negative numbers from.

    https://dl.dropboxusercontent.com/u/21390295/Arkiv.zip

  19. madpixels
    Member
    Plugin Author

    Posted 6 months ago #

    1. Second row has to contain data type of a coulmn (string, number, etc)
    2. Do not use spaces in your digits, so instead of -1 234 567 the value has to be -1234567

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.