RadChartView formatting a linear axis as currency?

[Rich]

Not sure if this is the right place to post, as I am not seeing any specific category for Charts(except the defunct one)

The issue:  I'm building my forst RadChartView based on a simple  query for "Vendor", and "Amount"

Amount, is a decimal in the database, and I'd like to have the Y axis display the values in currency format.

 

I'm not finding how to do this..?

 

Many thanks,

Rich

 

[Nadya | Tech Support Engineer]

Hello Rich,

In order to set some custom format to the Y-axis, you should access it and set its LabelFormat property. The following article demonstrates how you can access the Linear axis: https://docs.telerik.com/devtools/winforms/controls/chartview/axes/linear.

Since I am not sure which series you choose to use in your application I prepared an example with LineSeries that plots one categorical (X-axis) and one numerical axis (Y-axis). Please refer to the following code snippet:

public RadForm1()
{
    InitializeComponent();
    DataTable table = new DataTable();
    table.Columns.Add("Value", typeof(double));
    table.Columns.Add("Vendor", typeof(string));
    table.Rows.Add(305.50, "Sams");
    table.Rows.Add(380.80, "AliExpress");
    table.Rows.Add(550.50, "Alibaba");
    table.Rows.Add(120.00, "Marshal");
    table.Rows.Add(100.90, "Oysho");

    LineSeries lineSeries = new LineSeries();
    this.radChartView1.Series.Add(lineSeries);
    lineSeries.DataSource = table;
    lineSeries.ValueMember = "Value";
    lineSeries.CategoryMember = "Vendor";

    LinearAxis verticalAxis = lineSeries.VerticalAxis as LinearAxis;
    verticalAxis.LabelFormat = "{0:C}";
}

I hope this helps. Should you have further questions do not hesitate to contact me.

Regards,
Nadya
Progress Telerik

[Rich]

Howdy, & thanks for the reply.

I'm happy to report that I've fixed the issue.

I ended up simply plugging in your format string, into the  "Format String" of the "Linear Axis", under "Property Pages"

It's funny how easy it was: all I needed was the format string..

If I had explained in greater detail what I already had running, you would have likely proposed the same thing, I'm sure..

Thanks again!

Rich

 

[Nadya | Tech Support Engineer]

Hi Rich,

I am glad that you managed to found out the right solution for achieving your goal. If you have any further questions, I will be glad to help.

Regards,
Nadya
Progress Telerik