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.
Wed Aug 11, 2021 1:32 am
My chart's data area was originally columns is chart's x-axis and rows are chart's y-axis
But using spire.xls, after executing the j.DataRange = tmpDataSheet.Range[k.chartAfter];
columns becomes chart's y-axis and rows becomes chart's x-axis
how to keep the "columns is chart's x-axis and rows are chart's y-axis" after modifying DataRange.
-
kurikabocya
-
- Posts: 13
- Joined: Mon Aug 09, 2021 2:21 am
Wed Aug 11, 2021 9:22 am
Hello,
Thanks for your inquiry.
Please use the following code to achieve your requirement. If there is any question, please feel free to write back.
- Code: Select all
j.DataRange = tmpDataSheet.Range[k.chartAfter];
j.SeriesDataFromRange = false;
Sincerely,
Annika
E-iceblue support team
-
Annika.Zhou
-
- Posts: 1651
- Joined: Wed Apr 07, 2021 2:50 am
Thu Aug 19, 2021 8:12 am
Hello,
Hope you are doing well!
Did the code we provided work for you? Any feedback will be greatly appreciated.
Sincerely,
Annika
E-iceblue support team
-
Annika.Zhou
-
- Posts: 1651
- Joined: Wed Apr 07, 2021 2:50 am
Thu Aug 19, 2021 8:32 am
Sorry, I won't try it.
Because only one month is no meaning to us.
-
kurikabocya
-
- Posts: 13
- Joined: Mon Aug 09, 2021 2:21 am