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
  • Mike, I don't believe you can show currency symbols in those situations, but maybe the legend (showLegend) option would help - maybe set the label to "Spend ($)" and then switch the legend on? I might even be considered the right place to show the dollar symbol , and the tooltip will show something like "Spend ($): 1000".

    For your second point, it doesn't look like you can format the values - everything I've tried is ignored. If a value of, 1354.70 is entered, it will strip the trailing zero, but 1354.07 will display correctly.
Reply
  • Mike, I don't believe you can show currency symbols in those situations, but maybe the legend (showLegend) option would help - maybe set the label to "Spend ($)" and then switch the legend on? I might even be considered the right place to show the dollar symbol , and the tooltip will show something like "Spend ($): 1000".

    For your second point, it doesn't look like you can format the values - everything I've tried is ignored. If a value of, 1354.70 is entered, it will strip the trailing zero, but 1354.07 will display correctly.
Children
No Data