after modifying datarange, col(x)/row(y) became col(y)/row(x

[kurikabocya]

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.

[Annika.Zhou]

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]

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

[kurikabocya]

Sorry, I won't try it.
Because only one month is no meaning to us.