HippoEngine en = new HippoEngine();
en.DataType = DataSourceType.Excel;
en.Query = "select * from [Sheet1$]";
en.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=`C:\Users\neohippo\Downloads\히포차트데이터.xlsx`;Extended Properties=`Excel 12.0;HDR=YES`";
SeriesList sList = en.GetSeriesList(DataSourceType.Excel, "ddd", "A", "B", "C", "D");
sList.AxisFactor.AxisItems.Add(new Axis(AxisType.Ytype));
sList.AxisFactor.AxisItems.Add(new Axis(AxisType.Ytype));
sList.AxisFactor.AxisItems.Add(new Axis(AxisType.Ytype));
sList.SeriesCollection[0].AxisIndex = 0;
sList.SeriesCollection[1].AxisIndex = 1;
sList.SeriesCollection[2].AxisIndex = 2;
sList.SeriesCollection[3].AxisIndex = 3;
this.hHippoChart1.SeriesListDictionary.Add(sList);
this.hHippoChart1.DrawChart();
this.hHippoChart1.SeriesListDictionary[0].AxisFactor.YAxis.SetAxisStep(
this.hHippoChart1.SeriesListDictionary[0].AxisFactor.YAxis.AnalysisItems[AnalysisCategory.Min].Value,
this.hHippoChart1.SeriesListDictionary[0].AxisFactor.YAxis.AnalysisItems[AnalysisCategory.Max].Value,
0.1);
foreach(Axis ax in this.hHippoChart1.SeriesListDictionary[0].AxisFactor.AxisItems)
{
ax.SetAxisStep(ax.AnalysisItems[AnalysisCategory.Min].Value, ax.AnalysisItems[AnalysisCategory.Max].Value, 0.1);
}
this.hHippoChart1.DrawChart();
Dim en As New. HippoEngine()
en.DataType = DataSourceType.Excel
en.Query = "select * from [Sheet1$]"
en.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=`C:\Users\neohippo\Downloads\히포차트데이터.xlsx`;Extended Properties=`Excel 12.0;HDR=YES`"
Dim sList As SeriesList = en.GetSeriesList(DataSourceType.Excel, "ddd", "A", "B", "C", "D")
sList.AxisFactor.AxisItems.Add(New Axis(AxisType.Ytype))
sList.AxisFactor.AxisItems.Add(New Axis(AxisType.Ytype))
sList.AxisFactor.AxisItems.Add(New Axis(AxisType.Ytype))
sList.SeriesCollection(0).AxisIndex = 0
sList.SeriesCollection(1).AxisIndex = 1
sList.SeriesCollection(2).AxisIndex = 2
sList.SeriesCollection(3).AxisIndex = 3
Me.hHippoChart1.SeriesListDictionary.Add(sList)
Me.hHippoChart1.DrawChart()
Me.hHippoChart1.SeriesListDictionary(0).AxisFactor.YAxis.SetAxisStep(Me.hHippoChart1.SeriesListDictionary(0).AxisFactor.YAxis.AnalysisItems(AnalysisCategory.Min).Value, Me.hHippoChart1.SeriesListDictionary(0).AxisFactor.YAxis.AnalysisItems(AnalysisCategory.Max).Value, 0.1)
For Each ax As Axis In Me.hHippoChart1.SeriesListDictionary(0).AxisFactor.AxisItems
ax.SetAxisStep(ax.AnalysisItems(AnalysisCategory.Min).Value, ax.AnalysisItems(AnalysisCategory.Max).Value, 0.1)
Next
Me.hHippoChart1.DrawChart()