📄 pareto.aspx
字号:
<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING"%>
<%@ Import Namespace="System.Drawing" %>
<HTML>
<HEAD>
<TITLE>.netCHARTING Sample</TITLE>
<script runat="server">
void Page_Load(Object sender,EventArgs e)
{
Chart.Type = ChartType.Combo;//Horizontal;
Chart.Width = 600;
Chart.Height = 350;
Chart.TempDirectory = "temp";
Chart.Debug = true;
Chart.Title = "Pareto Chart";
Chart.DefaultSeries.DefaultElement.ShowValue = true;
// This sample will demonstrate how create a pareto chart.
// *DYNAMIC DATA NOTE*
// This sample uses random data to populate the chart. To populate
// a chart with database data see the following resources:
// - Classic samples folder
// - Help File > Data Tutorials
// - Sample: features/DataEngine.aspx
SeriesCollection mySC = getRandomData();
// First we need to sort the element in descending order by the y value.
mySC[0].Sort(ElementValue.YValue,"DESC");
// For this sample to work correctly we need to specify an axis for our series and then pass it to the
// getParetoSeries method.
mySC[0].YAxis = new Axis();
// Change the column label alignment.
mySC[0].DefaultElement.SmartLabel.Alignment = LabelAlignment.Center;
// Add the random data.
Chart.SeriesCollection.Add(mySC[0]);
Chart.SeriesCollection.Add(getParetoSeries(mySC[0],mySC[0].YAxis));
}
SeriesCollection getParetoSeries(Series s,Axis a)
{
// This method will return 2 series in order to create the pareto chart.
Series result = new Series();
Series result2 = new Series();
double sum = s.Calculate("",Calculation.Sum).YValue;
double runningSum = 0;
// The first series will be the visible line, it's y values will be the running sum but we will set the labels
// to represent the percentages. The reason the series needs the running sum values is because we want it to start
// at the top of the first column and so it also needs to be on the same y axis as the original series.
// The second series will be there to relate to the percentage labels of the first series to a percent axis so we set those
// element values to the percent values.
foreach(Element el in s.Elements)
{
runningSum += el.YValue;
Element curEl = new Element(el.Name,runningSum);
curEl.SmartLabel.Text = (runningSum*100/sum).ToString("0") + "%";
result.Elements.Add(curEl);
result2.Elements.Add(new Element(el.Name,runningSum*100/sum));
}
result.Type = SeriesType.Line;
// The visible series needs to be on the specified axis.
result.YAxis = a;
// Add the percentage axis.
result2.YAxis = new Axis();
result2.YAxis.Percent = true;
result2.YAxis.Orientation = dotnetCHARTING.Orientation.Right;
// In order for the two axes to match the first series y axis will need to end at the running sum of the values.
result.YAxis.Maximum = sum;
// We dont really want to show the series on the chart so we will set the element colors to empty and get rid of the
// legend entry.
result2.Type = SeriesType.Marker;
result2.DefaultElement.Color = Color.Empty;
result2.LegendEntry.Visible = false;
// Add the series to a collection and return it.
SeriesCollection sc = new SeriesCollection();
sc.Add(result);
sc.Add(result2);
return sc;
}
SeriesCollection getRandomData()
{
SeriesCollection SC = new SeriesCollection();
Random myR = new Random(1);
for(int a = 0; a < 1; a++)
{
Series s = new Series();
s.Name = "Series " + a;
for(int b = 0; b < 4; b++)
{
Element e = new Element();
e.Name = "Element " + b;
//e.YValue = -25 + myR.Next(50);
e.YValue = myR.Next(50);
s.Elements.Add(e);
}
SC.Add(s);
}
// Set Different Colors for our Series
SC[0].DefaultElement.Color = Color.FromArgb(49,255,49);
return SC;
}
</script>
</HEAD>
<BODY>
<DIV align="center">
<dotnet:Chart id="Chart" runat="server" Width="568px" Height="344px">
</dotnet:Chart>
</DIV>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -