ZenEntSEA

Hmmm…. I think I’ll stick with ticks and hope for a solution.

I can’t split the data into 3 charts. My use is to rank 27 players, as they progress through a series of competitions. But they all need to appear on the same chart at once, since they move from the bottom, to the middle and top, and all over through the course of the competitions over 12 weeks, and the chart is to track them as they progress through it.

Let me if/when you get a chance to look at the test case.

(I guess I should have said I’m a “sole proprietor”, as I do not have any employees, or have a desire to own a company that does. Just me.)

I guess I should also tell you that I DO NOT need to use “ticks”.

What I’m trying to achieve is to split the charts display into 3 sections, thirds of equal amount, 1 through 27. The data is locked into 27 being the highest, so I’m trying to visually represent the bottom, middle and top third.

If there is an easier way to do this, I’m game.

Forgot the link.

Thanks so much…. but,

On my page its still not reading the URL encodes properly. I’m getting ticks on 1,2,5,7,8,9, which looks like its stripping the endodes and only seeing their numbers, and adding ticks for them.

Damn this is a tough one!

BTW, I read your profile, and assure you I am not “pro-capitalism”. I’m a small business owner who escaped my corporate overlords 10 years ago. But I get it now, after reading your story. Cheers.

No entitled malice, or haughtiness intended. Sorry if it came across that way. Looking forward to your thoughts on my issue when you can get to it.

1. I realize I’m not your “highest priority”, I never claimed to be, or insinuated that…. or even asked for that.

2. I only “prodded” because your previous replies were so quick, combined with you marking this support thread as ‘resolved’, led me to believe this was not on your radar any longer, but my errors persist.

3. “I think I’ll ignore this for a while longer.” Have I done anything to upset you? If so, I apologize, but I feel I’ve been nothing but thankful of your help, and making the changes you suggest.

Again….. I appreciate your help.

Nothing huh?

Well that’s strange because I can get to the Google Doc just fine, Its ‘view only’ in this screenshot I took after logging out. I also have checked from multiple computers/browsers, not logged into google, and its there too. Also the page I’m testing this on has a couple tables from the same spreadsheet all displaying fine, using their own shortcode with this same gdoc.

Here is the new shortcode after your suggestions, still not working:

[gdoc key="https://docs.google.com/spreadsheets/d/1hOJPFL9VrwBYYn0OKeVwI2MwgxPX0lyzpx0bpIBarHw/edit#gid=1314876059" chart="Line" chart_chart_area='{"width":"90%", "height":"75%"}' chart_background_color='{"fill":"#292929"}' chart_v_axis='{"ticks":%5B 9,18,27%5D, "gridlines": {"color": "#202020"}}' chart_h_axis='{"textPosition":"bottom", "textStyle": {"color": "#CBCBCB", "fontSize": "10"}}' chart_legend='{"position": "top", "maxLines": "3", "alignment": "center", "textStyle": {"color": "#CBCBCB", "fontSize": "10"}}' chart_height="500" chart_width="100%"]

Here is a test page outside our pay wall that I copied the shortcode into so you can see the error.

I appreciate your help.

Shortcode:

[gdoc key="https://docs.google.com/spreadsheets/d/1hOJPFL9VrwBYYn0OKeVwI2MwgxPX0lyzpx0bpIBarHw/edit#gid=1314876059" chart="Line" chart_chart_area='{"width":"90%", "height":"75%"}' chart_background_color='{"fill":"#292929"}' chart_v_axis='{"ticks": %5B 5,10,15,20 %5B "gridlines": {"color": "#202020"}}' chart_h_axis='{"textPosition":"bottom", "textStyle": {"color": "#CBCBCB", "fontSize": "10"}}' chart_legend='{"position": "top", "maxLines": "3", "alignment": "center", "textStyle": {"color": "#CBCBCB", "fontSize": "10"}}' chart_height="500" chart_width="100%"]

Site/page is not live.

Error appears on page where chart should be. Red box stat states “b is undefined”.

Read the FAQ, found the URL encode equivalents. Still not quite sure how to incorporate that into your shortcode:

chart_v_axis='{"ticks": %5B 9,18,27 %5D, "gridlines": {"color": "#202020"}}'

Still gives error.

I see that for an array, it should look like this (from the page you referenced):

vAxis: { ticks: [5,10,15,20] }

But when I attempt to use [ or ], I get an error. SHould I different character be substituted for the shortcode, like = instead of :?

Thanks, that worked!