Line Chart - $ Sign in X & Y Axis

[Swapnil Patil]

How to show "$" Sign on X and Y Axis before values...???

[Roni Biran]

You write a function that goes over all datatable rows and set the column's value to be with $ sign

On Sep 24, 2011, at 8:41 AM, Swapnil Patil <swapnil...@gmail.com> wrote:

How to show "$" Sign on X and Y Axis before values...???

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[ChartMan]

Use formatted value and leave the value as it is.

ChartMan

[asgallant]

To format the axes, set the h/vAxis.format property of the options:

hAxis: {format: '$#,###'}

vAxis: {format: '$#,###'}

Format takes an ICU pattern set to format the values (this is different from data formatting using DataTable#NumberFormat method).

[Swapnil Patil]

var formatter = new google.visualization.NumberFormat(
{ prefix: '$'}
);
formatter.format(data, 1);

Thanks everyone.
Used this to format the values. But this only displays $ sign in tool
tip only and not on X Axis and Y axis labels.

On Sep 26, 5:47 pm, asgallant <drew_gall...@abtassoc.com> wrote:
> To format the axes, set the h/vAxis.format property of the options:
>
> hAxis: {format: '$#,###'}
> vAxis: {format: '$#,###'}
>

> Format takes an ICU pattern set<http://icu-project.org/apiref/icu4c/classDecimalFormat.html#_details>to format the values (this is different from
> *data* formatting using DataTable#NumberFormat method).

[asgallant]

Use the h/vAxis format options I listed to format the axes.

[Swapnil Patil]

Thanks asgallant !!!!

var formatter = new google.visualization.NumberFormat(
{ prefix: '$'}
);
formatter.format(data, 1);

and

hAxis: {format: '$#,###'}
vAxis: {format: '$#,###'}

acts one and the same. Both shows tooltip value formatted with $ sign
but $ sign doesn't appears on Y Axis labels.

[asgallant]

What kind of chart are you using?  Typically, one axis is a category axis, and will use whatever you put in column 0 as the axis values.  Since the category column is required to be a string, you'll have to add the $ yourself to each one, if that's what you are looking for.

[Swapnil Patil]

Dear asgallant, here is the source elements.

here the data table columns containing cuYear and pastyr with money
values.
Objective is to custom format the tooltip text and show Y Axis Lables
with cuYear values with the $ sign.
Hope it helps to understand the objective.

google.load('visualization', '1', { packages: ['corechart'] });

var data = new google.visualization.DataTable();
data.addColumn('string', 'x');
data.addColumn('number', cuYear);
data.addColumn('number', pastyr);

var formatter = new google.visualization.NumberFormat(
{ prefix: '$'}
);
formatter.format(data, 1);

formatter.format(data, 2);

new
google.visualization.LineChart(document.getElementById('visualization')).
draw(data,
{
curveType: "none",
titlePosition: 'out',
chartArea: { left: 70, top: 30 },
hAxis: { slantedText: false, textStyle: { color:
'#94511A', fontName: 'Arial,Helvetica,sans-serif', fontSize: 11} },
vAxis: { textStyle: { color: '#94511A', fontName:
'Arial,Helvetica,sans-serif', fontSize: 11 }, minValue: 0 },
width: 715,
height: 270,
legend: 'right',
pointSize: 3,
backgroundColor: '#FFFDEC',
legendBackgroundColor: "#FFFBD0",
legendHeight: 375,
legendTextStyle: { color: '#94511A', fontName:
'Arial', fontSize: 10 },
title: 'Title',
titleColor: "#94511A",
titleTextStyle: { color: '#94511A', fontName:
'Arial,Helvetica,sans-serif', fontSize: 11 }
});
}

[asgallant]

If you add:

format: "$#,###"

to the vAxis option, it should be putting $'s on the Y axis.  It doesn't do anything with the tooltips.

[Swapnil Patil]

Dear asgallant ....!! Thank you very much.

This works....i had tried this 2-3 times after your reply but wasn't
working. But rechecked today n it works.
Many thanks.
Can you please take a look at this discussion.
http://groups.google.com/group/google-visualization-api/browse_thread/thread/db63744f7d0b6379

[Ravish Kumar]

But this is not working when i am using behind code

 

[Reshma]

Is there a way to add $ prefix with format : 'short' on X?

[Yishai Levenglick]

This is my hope to find for today

looking through the web, I found this answer but it's not very satisfactory especially for the React wrapper