glatze1001

Thanks Meitar. Now it is working well!

When I call for a “geo” chart a “column” chart is displayed. Here my shortcode:

[gdoc key=”https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=415009838″ query=”select C,D” chart=”geo” colors=”green red” chart_v_axis= ‘{“format”:”#.##%”}’ chart_height = 400 chart_width = 900 chart_font]

Meitar,

Thanks for your quick reply. I speak about Google Geocharts:
https://developers.google.com/chart/interactive/docs/gallery/geochart

Regards
Roberto

Meitar,

How can I apply the different configurations:
https://developers.google.com/chart/interactive/docs/gallery/candlestickchart#configuration-options

For example if I wanna set the “candlestick.fallingColor.fill” to red. How do I incorporate that into my code?

[gdoc key=”https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0″ http_opts='{“timeout”:30}’ query=”select B,CC,CD,CE,CF limit 14″ chart=”candlestick” use_cache=”no” chart_height = 400 chart_width = 800 chart_font_size =12 chart_colors=”green orange” chart_h_axis ='{“slantedText”: true, “slantedTextAngle”:25}’ chart_v_axis= ‘{“format”:”#.##%”}’ style='{“candlestick.fallingColor.fill”: “red”}’ ]

Thanks

Yes, with the google example.

[gdoc key=”https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0″ query=”select B,cc,cd,ce,cf” chart=”candlestick” ]

Why don’t you show me your code?

Hi Metiar,

I want to start my chart at a certain value instead of 0 what is the default value.

Any idea how I can set the minimum value for the x-axis? I could not find it in the x-axis properties.

Regards
Roberto

Good Morning Sir,
Just relax: A simple delay before displaying would do the job. Any change that this funcion is already provided by google and I with my meodiocre IT knowledge does not know?

The issue seems that google finance returns the value “loading” while closing prices are downloaded. So your plug-in regards the sheet as ready.

Find below an example:¨
https://www.invest-to-retire.ch/portfolio/

Hi Meitar,

Unfortunately this did not solve the issue. I just had the content stored in cache.

Again: My spreadsheet needs about 10 seconds to calculate, but the spreadsheet viewer does not allow the sheet to fully calculate before it displays the content. My Sheet actually delivers values, but they are wrong since I am downloading data via Google Finance. So the your plugin should wait 10s and only then display.

With the timeout command the content of the webpage is not delayed, it is displayed more or less immediatly. It does not matter if I give a 10s or a 60s timeout.

Wooh! I tried to solve this issue for over a month. Ok. Will stop bothering you. Thanks again!

Meitar,
Thanks for your help and pacience! Enjoy your day.
Greeting from the land of cows and chocolate (Switzerland)

Thanks for your quick supply. I am not really an expert. How do I combine the “hAxis.slantedText:true” and “hAxis.slantedTextAngle:90” command in a simmple “google spreadsheet viewer” column chart?

With labels I mean x-axis labels.