Spread Windows Forms 6.0 Product Documentation
Using Raw and Represented Data
Support Options
Spread Windows Forms 6.0 Product Documentation > Developer's Guide > Working with the Chart Control > Creating Charts > Connecting to Data > Using Raw and Represented Data

Glossary Item Box

You can set the scale of the data before displaying the data.

For example, if the data values are in the millions, you may wish to display them using a much smaller scale such as hundreds (100,000,000 vs 100). Use the DisplayUnits property in the ValueAxis class to set the scale.

Using Code

Use the DisplayUnits property to create a smaller scale on the axis.

Example

The following example uses the DisplayUnits property.

C# Copy Code
FarPoint.Win.Chart.BarSeries series = new FarPoint.Win.Chart.BarSeries();
 
series.Values.Add(10000.0);
 
series.Values.Add(20000.0);
 
series.Values.Add(40000.0);
 
series.Values.Add(80000.0);
 
FarPoint.Win.Chart.YPlotArea plotArea = new FarPoint.Win.Chart.YPlotArea();
 
plotArea.Location = new PointF(0.2F, 0.2F);
 
plotArea.Size = new SizeF(0.6F, 0.6F);
 
plotArea.XAxis.Title = "Entry";
 
plotArea.XAxis.TitleVisible = true;
 
plotArea.YAxes[0].DisplayUnits = 1000.0;
 
plotArea.Series.Add(series);
 
FarPoint.Win.Chart.ChartModel model = new FarPoint.Win.Chart.ChartModel();
 
model.PlotAreas.Add(plotArea);
 
FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart();
 
chart.Size = new Size(200, 200);
 
chart.Location = new Point(100, 100);
 
chart.Model = model;
 
fpSpread1.Sheets[0].Charts.Add(chart);
 
VB Copy Code
Dim series As New FarPoint.Win.Chart.BarSeries()
 
series.Values.Add(10000.0)
 
series.Values.Add(20000.0)
 
series.Values.Add(40000.0)
 
series.Values.Add(80000.0)
 
Dim plotArea As New FarPoint.Win.Chart.YPlotArea()
 
plotArea.Location = New PointF(0.2F, 0.2F)
 
plotArea.Size = New SizeF(0.6F, 0.6F)
 
plotArea.XAxis.Title = "Entry" 'IndexAxis
 
plotArea.XAxis.TitleVisible = True 'IndexAxis
 
plotArea.YAxes(0).DisplayUnits = 1000.0 'ValueAxis
 
plotArea.Series.Add(series)
 
Dim model As New FarPoint.Win.Chart.ChartModel()
 
model.PlotAreas.Add(plotArea)
 
Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart()
 
chart.Size = New Size(200, 200)
 
chart.Location = New Point(100, 100)
 
chart.Model = model
 
FpSpread1.Sheets(0).Charts.Add(chart)
 

Return to Connecting to Data.

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.