I have 2 questions, first is the yAxis value range determined by the values that

I have 2 questions, first is the yAxis value range determined by the values that it is exposing and can these be set with a currency symbol since the data I am exposing are dollars? Second, I have a column chart where I am displaying by year the annual amount that we spend on a vendor. This value is a decimal in the database (e.g. 650123.00). I want to show the data labels but this number is coming back like this: 650123. I attempted to add the dollar function but it has no affect. Here is my code:

a!columnChartField(
label: "Spend (in 1,000s):",
labelPosition: "ADJACENT",
categories: {"2013", "2014", "2015 forecasted"},
series: {
a!chartSeries(label: "Dollars", data: {dollar((rf!previousyear),2,1), dollar(rf!prioryear,2,1), dollar(rf!currentyear,2,1)},color: "GREEN")
},
xAxisTitle: "Spend by Year",
yAxisTitle: "Dollars",
stacking: "NONE",
showDataLabels: true,
showLegend: false,
showTooltips: true
),



OriginalPostID-142118

OriginalPostID-142118

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data