It draws custom charts i.e. one type of chart is column and other is Line chart. When we click on a column bar chart from it, it shows that the series are considered columnwise for data in sheet. How can we switch the axis so that charts are drawn for horizontal data? I hope you can understand what I mean.
As I understand from your query, I think you want to specify the source data for different chart series row by row. You may put “false” for the “isVertical” Boolean parameter in SeriesCollection.Add method. See the sample line of code for your reference:
e.g Sample code:
…
// Adding NSeries (chart data source) to the chart ranging from “A1” cell to “B4”
chart.NSeries.Add(“A1:B4”, false);
Hope, this helps a bit.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.