Hi Donna, Since you are using the ChartEditor through Google Sheets, you should probably ask on a forum for Sheets. Here is a place to start: https://productforums.google.com/forum/#!forum/docs
But I can tell you what should be possible in the underlying Charts functionality. The chart title cannot be aligned, unfortunately. The axis ticks could be formatted with a format option, but there is a risk doing that automatically because the tick values might need the precision of a couple decimal digits. If you specify an automatic number of gridlines (as opposed to the default of 5) you might get better tick values. On Mon, May 9, 2016 at 2:38 PM, Donna Eaker <[email protected]> wrote: > Hi. Not sure if I'm in the right place or not but I have some questions > regarding charts in google sheets. I have a ton of them in excel and was > looking to convert/upload them into google sheets. So, to kind of learn my > way around I uploaded one of my charts and currently have 2 questions. > > 1) How do I center my chart title. It doesn't give me that option. Not > even under advanced editing. > 2) How do I get my vertical axis to a whole number. All I get is a > little box with a min & max to choose from. I just need to change the > number from a decimal to a whole number. I've included a picture to show > what I get. > > > > <https://lh3.googleusercontent.com/-CaPZ0NCWdp8/VzDY9t-Y8cI/AAAAAAAAD6k/YUW3YRCifaAmj5xq7xQC92tIAQnXc-jlACLcB/s1600/vertical_axis.png> > > > > On Sunday, May 19, 2013 at 11:57:30 PM UTC-4, asgallant wrote: >> >> You can use the vAxis.format option to format the vertical axis (it takes >> a string of ICU number pattern >> <http://icu-project.org/apiref/icu4c/classDecimalFormat.html#_details>). >> You can add in prefixes, suffixes, separators, set number of decimal places >> and significant figures, use exponential notation, etc. You cannot, >> however, shorten a number like 120000 to "120 thousand" with the format >> string - you would have to manipulate your data (divide all values by 1000) >> and then add "thousand" as a suffix in the format. >> >> On Sunday, May 19, 2013 8:45:39 PM UTC-4, Josh Grant wrote: >>> >>> Is it possible to format the values used on the vertical axis somehow? >>> For example, to use a numerical value in the data and to have a >>> formatted value be displayed instead? >>> >>> E.g., the value is 120000 but the formatted value would be "120 >>> thousand" or "120 elephants". >>> >> > ********************************************************** > Privileged and/or confidential information may be contained in this > message. If you are not the addressee indicated in this message (or are not > responsible for delivery of this message to that person) , you may not copy > or deliver this message to anyone. In such case, you should destroy this > message and notify the sender by reply e-mail. > If you or your employer do not consent to Internet e-mail for messages of > this kind, please advise the sender. > Shaw Industries does not provide or endorse any opinions, conclusions or > other information in this message that do not relate to the official > business of the company or its subsidiaries. > ********************************************************** > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > https://groups.google.com/group/google-visualization-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-visualization-api/afbcbc3e-041d-48c6-890b-2e303977ab9b%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/afbcbc3e-041d-48c6-890b-2e303977ab9b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJMsX26yMs_1-SX9ObLr-9Fh%3DO9bpFU3bDX2TaivNMRhYg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
