|
|
円チャート
SPREADでは以下の4種類の円チャートが提供されています。
チャートはエンドユーザーが自由に移動したりリサイズすることができます。
| | A | B | C | D | E | F |
| 1 | | S | E | W | N | NE |
| 2 | S1 | 50 | 25 | 85 | 30 | 26 |
| 3 | S2 | 92 | 14 | 15 | 24 | 65 |
| 4 | S3 | 65 | 26 | 70 | 60 | 43 |
| 5 | S4 | 24 | 80 | 26 | 11 | 27 |
|
|
ソースコード
別ウィンドウで表示
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class chart_piechart : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
// SPREADの設定
InitSpread(FpSpread1);
// シート設定
InitSpreadStyles(FpSpread1.Sheets[0]);
}
private void InitSpread(FarPoint.Web.Spread.FpSpread spread)
{
spread.CssClass = "spreadStyle2";
spread.UseClipboard = false;
}
private void InitSpreadStyles(FarPoint.Web.Spread.SheetView sheet)
{
// フォントサイズの設定
sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%");
sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%");
sheet.RowCount = 5;
sheet.ColumnCount = 6;
// 2Dを選択
RadioButtonList1.SelectedIndex = 0;
// テストデータの設定
sheet.SetClipValue(0, 1, 1, 5, "S\tE\tW\tN\tNE");
sheet.SetClipValue(1, 0, 1, 6, "S1\t50\t25\t85\t30\t26");
sheet.SetClipValue(2, 0, 1, 6, "S2\t92\t14\t15\t24\t65");
sheet.SetClipValue(3, 0, 1, 6, "S3\t65\t26\t70\t60\t43");
sheet.SetClipValue(4, 0, 1, 6, "S4\t24\t80\t26\t11\t27");
// シリーズを作成
FarPoint.Web.Chart.PieSeries series1 = new FarPoint.Web.Chart.PieSeries();
series1.SeriesName = "Series 1";
series1.CategoryNames.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text);
series1.Values.DataSource = new FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$2:$F$2");
// プロット領域を作成します
FarPoint.Web.Chart.PiePlotArea plotArea = new FarPoint.Web.Chart.PiePlotArea();
plotArea.Location = new System.Drawing.PointF(0.2f, 0.2f);
plotArea.Size = new System.Drawing.SizeF(0.6f, 0.6f);
plotArea.Series.AddRange(new FarPoint.Web.Chart.Series[] { series1 });
// 凡例を設定します
FarPoint.Web.Chart.LegendArea legend = new FarPoint.Web.Chart.LegendArea();
legend.Location = new System.Drawing.PointF(0.995f, 0.5f);
legend.AlignmentX = 1f;
legend.AlignmentY = 0.5f;
// チャートモデルに各情報を追加します
FarPoint.Web.Chart.ChartModel model = new FarPoint.Web.Chart.ChartModel();
model.LegendAreas.Add(legend);
model.PlotAreas.Add(plotArea);
// SPREADチャートにチャートモデルを設定します
FarPoint.Web.Spread.Chart.SpreadChart chart = new FarPoint.Web.Spread.Chart.SpreadChart();
chart.Height = 300;
chart.Width = 400;
chart.Left = 50;
chart.Top = 120;
chart.Model = model;
sheet.Charts.Add(chart);
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
FpSpread1.SaveChanges();
if (FpSpread1.ActiveSheetView.Charts.Count > 0)
{
if (RadioButtonList1.SelectedIndex == 1)
{
FpSpread1.ActiveSheetView.Charts[0].ViewType = FarPoint.Web.Chart.ChartViewType.View3D;
FpSpread1.ActiveSheetView.Charts[0].Model.PlotAreas[0].Elevation = 18;
FpSpread1.ActiveSheetView.Charts[0].Model.PlotAreas[0].Rotation = -24;
}
else
{
FpSpread1.ActiveSheetView.Charts[0].ViewType = FarPoint.Web.Chart.ChartViewType.View2D;
}
}
}
}
|
Partial Class chart_piechart
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
' SPREADの設定
InitSpread(FpSpread1)
' シート設定
InitSpreadStyles(FpSpread1.Sheets(0))
End Sub
Private Sub InitSpread(ByVal spread As FarPoint.Web.Spread.FpSpread)
spread.CssClass = "spreadStyle2"
spread.UseClipboard = False
End Sub
Private Sub InitSpreadStyles(ByVal sheet As FarPoint.Web.Spread.SheetView)
' フォントサイズの設定
sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%")
sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%")
sheet.RowCount = 5
sheet.ColumnCount = 6
' 2Dを選択
RadioButtonList1.SelectedIndex = 0
' テストデータの設定
sheet.SetClipValue(0, 1, 1, 5, "S" & vbTab & "E" & vbTab & "W" & vbTab & "N" & vbTab & "NE")
sheet.SetClipValue(1, 0, 1, 6, "S1" & vbTab & "50" & vbTab & "25" & vbTab & "85" & vbTab & "30" & vbTab & "26")
sheet.SetClipValue(2, 0, 1, 6, "S2" & vbTab & "92" & vbTab & "14" & vbTab & "15" & vbTab & "24" & vbTab & "65")
sheet.SetClipValue(3, 0, 1, 6, "S3" & vbTab & "65" & vbTab & "26" & vbTab & "70" & vbTab & "60" & vbTab & "43")
sheet.SetClipValue(4, 0, 1, 6, "S4" & vbTab & "24" & vbTab & "80" & vbTab & "26" & vbTab & "11" & vbTab & "27")
' シリーズを作成
Dim series1 As New FarPoint.Web.Chart.PieSeries()
series1.SeriesName = "Series 1"
series1.CategoryNames.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldCategoryName", "Sheet1!$B$1:$F$1", FarPoint.Web.Spread.Chart.SegmentDataType.Text)
series1.Values.DataSource = New FarPoint.Web.Spread.Chart.SeriesDataField(FpSpread1, "DataFieldValue", "Sheet1!$B$2:$F$2")
' プロット領域を作成します
Dim plotArea As New FarPoint.Web.Chart.PiePlotArea()
plotArea.Location = New System.Drawing.PointF(0.2F, 0.2F)
plotArea.Size = New System.Drawing.SizeF(0.6F, 0.6F)
plotArea.Series.AddRange(New FarPoint.Web.Chart.Series() {series1})
' 凡例を設定します
Dim legend As New FarPoint.Web.Chart.LegendArea()
legend.Location = New System.Drawing.PointF(0.995F, 0.5F)
legend.AlignmentX = 1.0F
legend.AlignmentY = 0.5F
' チャートモデルに各情報を追加します
Dim model As New FarPoint.Web.Chart.ChartModel()
model.LegendAreas.Add(legend)
model.PlotAreas.Add(plotArea)
' SPREADチャートにチャートモデルを設定します
Dim chart As New FarPoint.Web.Spread.Chart.SpreadChart()
chart.Height = 300
chart.Width = 400
chart.Left = 50
chart.Top = 120
chart.Model = model
sheet.Charts.Add(chart)
End Sub
Protected Sub RadioButtonList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadioButtonList1.SelectedIndexChanged
FpSpread1.SaveChanges()
If FpSpread1.ActiveSheetView.Charts.Count > 0 Then
If RadioButtonList1.SelectedIndex = 1 Then
FpSpread1.ActiveSheetView.Charts(0).ViewType = FarPoint.Web.Chart.ChartViewType.View3D
FpSpread1.ActiveSheetView.Charts(0).Model.PlotAreas(0).Elevation = 18
FpSpread1.ActiveSheetView.Charts(0).Model.PlotAreas(0).Rotation = -24
Else
FpSpread1.ActiveSheetView.Charts(0).ViewType = FarPoint.Web.Chart.ChartViewType.View2D
End If
End If
End Sub
End Class
|
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="piechart.aspx.cs" Inherits="chart_piechart" %>
<%@ Register Assembly="FarPoint.Web.SpreadJ" Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeaderPlaceHolder1" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:RadioButtonList ID="RadioButtonList1" runat="server" AutoPostBack="True"
RepeatDirection="Horizontal"
onselectedindexchanged="RadioButtonList1_SelectedIndexChanged">
<asp:ListItem Selected="True">2D</asp:ListItem>
<asp:ListItem>3D</asp:ListItem>
</asp:RadioButtonList>
<FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="#A0A0A0" BorderStyle="Solid"
BorderWidth="1px">
<CommandBar BackColor="#F6F6F6" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight"
ButtonShadowColor="ControlDark">
</CommandBar>
<Sheets>
<FarPoint:SheetView SheetName="Sheet1">
</FarPoint:SheetView>
</Sheets>
</FarPoint:FpSpread>
</asp:Content>
|
|