I would like to create a chart based on the principle described in the following post (using a secondary value axis)
Instead of showing the secondary data series as a line, I would like to use two columns to display both values for each category item. If I comment out the type property of the second data series, the resulting chart contains only one column for each category item. Can you please tell me what’s wrong?
If you don’t want to plot the second data series on secondary axis, you may just skip/exclude the code regarding plotting the second series on the secondary axis line.
If you still could not sort it out, kindly create a sample chart in MS Excel manually and post the generated xls file (containing the sample chart) here, we will check and tell you how to create such a chart using the Aspose.Cells for .NET APIs.
Please find attached further information about the mentioned issue. You can use the code and the xls file to create the initial chart. The excel files contains also worksheets showing different results based on the steps described below.
The chart contains 4 data rows (Master1, Master2, Detail1, Detail2). To reach the desired result it is necessary to perform the following steps (Excel)
Edit data row Detail1 à Set axis to Secondary
Edit data row Detail2 à Set axis to Secondary
Edit data row Master 2 à Set color and border to non
Edit data row Detail 1 à Set color and border to non
Now you should get a chart that looks like the one shown on Worksheet “Chart edited excel”
If I try to apply the procedure in my code, I get always a different result (see worksheet “Chart created with Aspose”, I just apply the first tow steps)