Issues regarding chart formatting

Hello,

We want to use your product to display the return of our fund, but I have run into a few issues:

1. How do I add a symbol to the vertical axis and to the numbers themselves? For example, 1%, 2%, 3%, or $1, $2, $3, etc. I want to display that our fund had a return of 20.12%, not just "20.12".

2. How do I add vertical lines as period separators? For example, a vertical line every 3 months, or at every 3rd horizontal value, etc.

3. On the vertical axis, how do I edit the number separator? For example, instead of displaying numbers as "100, 200, 300", there is automatically added a space between the hundreds and tens, so the numbers look like "1 00, 2 00", 3 00", etc.

4. I want to edit the display range of the vertical axis from -25 to 225, but even if I put in those numbers in the start- and end field in the "Vertical Axis Values" at the backend, it still formats the chart from -1 00 to 3 00 (do note that the numbers are formatted as -1 00 to 3 00 instead of -100 to 300)

5. Each time the page loads, the page and its content finishes its loading first and then about a second or so later then the chart appears and the whole page expands downwards. How can I make the chart appear at the same time with the rest of the page's content, and thus avoiding the whole page expanding downwards when the chart appears?

You can see the chart here: www.minastir.com/sv/historical-returns

I really appreciate if you could take time to help me.

Thank you.

Hi Xenon

Thanks to contact us. You can set these parameter in chart formating section.
I have explain all your issues in image.from where you can add the format which you need.
and your last question of loading the chart after load the page content. Chart loading start after your page is loaded.

thanks

Hi Zaheer,

Thank you very much for your fast reply, I really appreciate it.

I still have an issue with question 2 regarding the vertical lines. Currently, I have the dates formatted as "string" in the "Horizontal value" format, but in the "Label Line Style" for Horizontal Axis, there is no "string" option for "Data type", only Decimal-, Scientific-, Currency-, etc.

When I choose "10" for "Number of labels", there is no change in the chart at all, regardless of what choice I make in "Data Type" (Decimal-, Scientific-, Currency-, etc.).


When I change the "Horizontal value format" from string to "Date", then I get lots of problems, see the attachment. I suspect this is because I have the wrong date format?

Currently, my dates are arranged as 2015-10-01, 2015-10-02, 2015-10-03, etc. How should the dates be formatted in order to work?


When I chose Horizontal value format as "date", in the "Label line style" I get to chose how to display the dates, e.g. mm/dd/yy, dd/mm/yy, dd/mon/yyyy, etc. How do I change this to yyyy-mm-dd, or how can I customize it?

Thank you once again for your time and help.

Hi again,

I think I managed to solve the date issue by changing the date input format to yyyy/mm/dd. But now I have some other problems.

1. If I put the date as 2015/12/31, hovering the bar displays the date as 31 dec-2015, but the horizontal axis displays it as 01-jan.-2016. Please see the attached picture where I tried two output styles, (dd/mon/yyyy) and (yyyy).

2. How do I format the values displayed when hovering a bar? In the attached picture, you can see the value for the bar 2015 (or 2016...) as 0.5738. I want this to be displayed as 57.28% just like the vertical axis which is 0%, 15%, 30%, etc.

3. How do I customize the style for the date to, for example, yyyy-mm-dd?

4. Adding vertical lines when the horizontal value is a date value works well, but it doesn't work when it is a string. Please help?

Thank you very much for your help.

Another question:

5. I tried to work around question 2 by changing the bar value from 0.5738 to 57.38 and then add "%" in the "Add String Before and after Vertical Value", but then the value in the vertical axis suddenly became percent values (0%, 1500%, 3000%) instead of the value that I expected (0%, 15%, 30%). If I changed the "%" to "p" then the number displayed correctly (0p, 15p, 30p).

Basically, I just want the vertical axis to display 0%, 15%, 30%, etc. and the value when hovering the bar to display 57.38%.

Please help?

We are looking into it. Please allow us sometime, Will get back to you soon....