Thanks!
On Thursday, March 13, 2014 4:28:25 PM UTC-4, asgallant wrote:
>
> You can set the format like this:
>
> var format = '#,###';
> if (<test for dollars>) {
> format = '$#,###';
> }
> else if (<test for percents>) {
> format = '#%';
> }
>
> chart.draw(data, {
> format: format
> });
>
> On Thursday, March 13, 2014 4:15:28 PM UTC-4, Novonod wrote:
>>
>> I wonder if anyone has a creative idea for tackling this problem.
>>
>> I have a chart that queries a spreadsheet and renders up to two column
>> values displayed on the Y Axis (the H axis is a range of years (rows)).
>> The column values are displayed upon user selection and can be a number ,
>> a dollar amount or a percent. Example: Column B-Number of units sold
>> (number), Column C-Total value of units sold ( $ ), D-Total Orders (number
>> ), E-cancelled orders(number), F-percentage of cancellation ( % ). My
>> problem is that the vAxis labels for the percents are being drawn out as
>> decimals. (0.25, 0.50, etc.), and I need them to display as percents. If
>> all columns were percents I could simply write options{vAxis:{format:
>> '##%'}}. I was thinking that I could change this according to case -- if
>> dollars format_variable = 'format: $##,###', if percent format_variable =
>> 'format:##%' , etc., but I have not been able to store the format in the
>> variable and get it to work.
>>
>> Any ideas?
>>
>> Thanks in advance!
>>
>
--
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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
