Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
Tue Jul 02, 2019 2:58 am
您好,想請問紅框圈起來的部分要如何操作才會不重疊?
或是說分別操作哪些類別可以指定兩個紅框位置絕對位置或相對位置。
- Code: Select all
var chart = excel.worksheet.Charts.Add(ExcelChartType.BarClustered);
chart.ChartTitle = "整體分析";
chart.DataRange = "另個紅框資料"
麻煩您了,感謝。
-
benjaminlin
-
- Posts: 3
- Joined: Tue Mar 19, 2019 10:12 am
Tue Jul 02, 2019 6:19 am
您好,
不好意思我這邊看不到您附加的圖片,不清楚您圈出的紅框到底是什麼部分。能否將您的圖片添加到压缩包再附加一次?或者您直接發送圖片到我們的郵箱 (
support@e-iceblue.com)。十分感謝!
Sincerely,
Nina
E-iceblue support team
-
Nina.Tang
-
- Posts: 1187
- Joined: Tue Sep 27, 2016 1:06 am
Tue Jul 02, 2019 8:05 am
Hi,
沒有直接的辦法來指定Title和PlotArea之間的絕對或相對位置,不過您可以嘗試用下面的代碼設置PlotArea的位置以達到您想要的效果。
- Code: Select all
chart.PlotArea.IsXMode = true;
chart.PlotArea.IsYMode = true;
chart.PlotArea.X = 600;
chart.PlotArea.Y = 600;
Sincerely,
Nina
E-iceblue support team
-
Nina.Tang
-
- Posts: 1187
- Joined: Tue Sep 27, 2016 1:06 am
Mon Jul 08, 2019 7:07 am
您好,
问题解决了吗?能否在方便的时候给我们一些反馈呢?十分感谢!
Sincerely,
Nina
E-iceblue support team
-
Nina.Tang
-
- Posts: 1187
- Joined: Tue Sep 27, 2016 1:06 am