FlexChart多轴绑定多个表

Richard.Ma

现有数据表结构为4字段 Col1、Col2、Col3、Col4，对应X轴绑定Col1，Y轴绑定Col2，Y2轴绑定Col3，Y3轴绑定Col4。
在DataSet中有n个数据表，现要将n个数据表的数据绘制到 FlexChart中。我在循环添加时的代码如下：

foreach (DataTable objTb in objDs)
{
var series1 = new Series()
{
Name = "Temperature(°C)",
Binding = "HighTemp",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)1,
DataSource = objTb,
AxisY = new Axis()
{
Position = Position.Left,
Title = "Temperature (°C)",
AxisLine = true,
}
};
this.flexChart1.Series.Add(series1);
var series2 = new Series()
{
Name = "Precipitation(mm)",
Binding = "Precipitation",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)2,
DataSource = objTb,
AxisY = new Axis()
{
Position = Position.Right,
Title = "Precipitation (mm)",
AxisLine = true,
},
};
this.flexChart1.Series.Add(series2);
var series3 = new Series()
{
Name = "PPL(lb)",
Binding = "PPL",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)7,
DataSource = objTb,
AxisY = new Axis()
{
Position = Position.Right,
Title = "PPL (mm)",
AxisLine = true,
},
};
this.flexChart1.Series.Add(series3);
}

复制代码

但是这样添加后，右边的Y轴会重复显示，但如果不在 new Series() 时设置“AxisY"，右侧又不显示轴，请问如何解决？
就是已添加的第二、三Y轴是否可以获取到？

Richard.Ma · Richard.Ma

你是给多个series 绑定同一个Y轴，那么应该是自己new一个Y轴对象出来，然后每次添加series时设置，这样才对

Richard.Ma · Richard.Ma

请上传一个重现问题的demo，我帮你排查一下原因，

ud7070 · ud7070

Richard.Ma 发表于 2023-5-10 17:56
请上传一个重现问题的demo，我帮你排查一下原因，

private void Form2_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
for (int i = 0; i < 3; i++)
{
DataTable objTb = new DataTable();
objTb.TableName = $"objTb{i + 1}";
objTb.Columns.Add("Col1", typeof(int));
objTb.Columns.Add("Col2", typeof(int));
objTb.Columns.Add("Col3", typeof(int));
objTb.Columns.Add("Col4", typeof(int));
for(int r = 0; r < 20; r++)
{
DataRow newRow = objTb.NewRow();
newRow[0] = r;
for (int c = 1; c < 4; c++)
{
newRow[c] = r * c + Math.Pow(i, c);
}
objTb.Rows.Add(newRow);
}
ds.Tables.Add(objTb);
}
List<Color> colorList = new List<Color>() { Color.Blue, Color.Red, Color.Green, Color.AliceBlue };
var chart = flexChart1;
chart.AxisX.Title = "Col1";
chart.AxisY.Title = "Col2";
chart.BindingX = "Col1";
chart.AxisX.AxisLine = true;
chart.AxisX.MajorGrid = true;
chart.AxisY.Position = Position.Left;
chart.AxisY.AxisLine = true;
for (int i = 0; i < ds.Tables.Count; i++)
{
var curSeries = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col2",
Binding = "Col2",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)1,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
};
chart.Series.Add(curSeries);
var seriesY2 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col3",
Binding = "Col3",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)2,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
AxisY = new Axis()
{
Position = Position.Right,
Title = "Y2(Col3)",
AxisLine = true,
LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
},
};
chart.Series.Add(seriesY2);
var seriesY3 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col4",
Binding = "Col4",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)7,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
AxisY = new Axis()
{
Position = Position.Right,
Title = "Y3(Col4)",
AxisLine = true,
LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
},
};
chart.Series.Add(seriesY3);
}
}

复制代码

ud7070 · ud7070

本帖最后由 ud7070 于 2023-5-11 08:53 编辑

Richard.Ma 发表于 2023-5-10 17:56
请上传一个重现问题的demo，我帮你排查一下原因，

又改了一下，轴不重复了，但是如果先添加一次曲线后，再在DataSet 中循环添加表时，右侧的Y2轴和Y3轴的刻度不会根据数据的变化而变化，但左侧的正常。

Richard.Ma · Richard.Ma

这个form有用其他的东西，这边运行不起来，请上传完整的一个demo项目上来

ud7070 · ud7070

Richard.Ma 发表于 2023-5-11 10:43
这个form有用其他的东西，这边运行不起来，请上传完整的一个demo项目上来

删除那行即可

删除"LogBase"配置

ud7070 · ud7070

Richard.Ma 发表于 2023-5-11 10:43
这个form有用其他的东西，这边运行不起来，请上传完整的一个demo项目上来

public partial class Form2 : Form
{
DataSet ds = new DataSet();
List<Color> colorList = new List<Color>() { Color.Blue, Color.Red, Color.Green, Color.AliceBlue };
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
for (int i = 0; i < 3; i++)
{
DataTable objTb = new DataTable();
objTb.TableName = $"objTb{i + 1}";
objTb.Columns.Add("Col1", typeof(int));
objTb.Columns.Add("Col2", typeof(int));
objTb.Columns.Add("Col3", typeof(int));
objTb.Columns.Add("Col4", typeof(int));
for(int r = 0; r < 20; r++)
{
DataRow newRow = objTb.NewRow();
newRow[0] = r;
for (int c = 1; c < 4; c++)
{
newRow[c] = r * Math.Pow((c + 1), 2) * (i == 0 ? 1 : Math.Pow(i, c)) + Math.Pow(i, c) + Math.Pow(r, i + c);
}
objTb.Rows.Add(newRow);
}
ds.Tables.Add(objTb);
}
var chart = flexChart1;
chart.BeginUpdate();
chart.AxisX.Title = "Col1";
chart.AxisY.Title = "Col2";
chart.BindingX = "Col1";
chart.AxisX.AxisLine = true;
chart.AxisX.MajorGrid = true;
chart.AxisY.Position = Position.Left;
chart.AxisY.AxisLine = true;
//for (int i = 0; i < ds.Tables.Count; i++)
//for (int i = ds.Tables.Count - 1; i >= 0; i--)//可以看到Y3最大坐标
for (int i = 0; i < 1; i++)
{
var curSeries = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col2",
Binding = "Col2",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)1,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
};
chart.Series.Add(curSeries);
var seriesY2 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col3",
Binding = "Col3",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)2,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
//AxisY = new Axis()
//{
// Position = Position.Right,
// Title = "Y2(Col3)",
// AxisLine = true,
// LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
//},
};
if (!GetHaveTypeSeries("Col3"))
{
seriesY2.AxisY = new Axis()
{
Position = Position.Right,
Title = "Y2(Col3)",
AxisLine = true,
//LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
};
}
chart.Series.Add(seriesY2);
var seriesY3 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col4",
Binding = "Col4",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)7,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
//AxisY = new Axis()
//{
// Position = Position.Right,
// Title = "Y3(Col4)",
// AxisLine = true,
// LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
//},
};
if (!GetHaveTypeSeries("Col4"))
{
seriesY3.AxisY = new Axis()
{
Position = Position.Right,
Title = "Y3(Col4)",
AxisLine = true,
//LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
};
}
chart.Series.Add(seriesY3);
}
chart.EndUpdate();
chart.Refresh();
}
bool GetHaveTypeSeries(string ColName)
{
bool rst = false;
var chart = this.flexChart1;
foreach (Series s in chart.Series)
{
if (s.Binding == ColName)
{
rst = true;
break;
}
}
return rst;
}
private void button1_Click(object sender, EventArgs e)
{
var chart = flexChart1;
chart.BeginUpdate();
chart.AxisX.Title = "Col1";
chart.AxisY.Title = "Col2";
chart.BindingX = "Col1";
chart.AxisX.AxisLine = true;
chart.AxisX.MajorGrid = true;
chart.AxisY.Position = Position.Left;
chart.AxisY.AxisLine = true;
for (int i = 1; i < ds.Tables.Count; i++)
{
var curSeries = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col2",
Binding = "Col2",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)1,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
};
chart.Series.Add(curSeries);
var seriesY2 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col3",
Binding = "Col3",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)2,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
//AxisY = new Axis()
//{
// Position = Position.Right,
// Title = "Y2(Col3)",
// AxisLine = true,
// LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
//},
};
if (!GetHaveTypeSeries("Col3"))
{
seriesY2.AxisY = new Axis()
{
Position = Position.Right,
Title = "Y2(Col3)",
AxisLine = true,
//LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
};
}
chart.Series.Add(seriesY2);
var seriesY3 = new Series()
{
Name = $"{ds.Tables[i].TableName}_Col4",
Binding = "Col4",
ChartType = ChartType.SplineSymbols,
SymbolMarker = (SymbolMarker)7,
Style =
{
StrokeWidth = 2,
StrokeColor = colorList[i],
},
DataSource = ds.Tables[i],
//AxisY = new Axis()
//{
// Position = Position.Right,
// Title = "Y3(Col4)",
// AxisLine = true,
// //LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
//},
};
if (!GetHaveTypeSeries("Col4"))
{
seriesY3.AxisY = new Axis()
{
Position = Position.Right,
Title = "Y3(Col4)",
AxisLine = true,
//LogBase = (ConfigurationManager.AppSettings["Y2AxisLog"].ToString().ToLower() == "true") ? double.Parse(ConfigurationManager.AppSettings["Y2AxisLogNum"].ToString()) : double.NaN,
};
}
chart.Series.Add(seriesY3);
}
chart.EndUpdate();
chart.Refresh();
}
}

复制代码

ud7070 · ud7070

Richard.Ma 发表于 2023-5-11 11:29
你是给多个series 绑定同一个Y轴，那么应该是自己new一个Y轴对象出来，然后每次添加series时设置，这样才对 ...

好的，我试一下

Richard.Ma · Richard.Ma

好的

		自动登录	找回密码
密码			立即注册

[已处理] FlexChart多轴绑定多个表

最佳答案

9 个回复

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

讲师达人

悬赏达人