Second Axis having the same value as the first axis

Aspose.Cells Product Family
1

Hi,
I wanted to know if it is possible to have a secondary axis on a pivot chart, but the value of that axis is the same as the primary axis.

See my sample. AxisSample.zip (15.2 KB)

2

@rmacero,

Thanks for the sample file.

I have checked it a bit. If MS Excel supports this feature to have different values for secondary axis, then Aspose.Cells may support it as well. I evaluate it a bit in MS Excel but could not accomplish the task for pivot chart manually in MS Excel. If you could do it in MS Excel manually, please share your sample Excel file containing your desired pivot chart based on the pivot table, we will check on how to do it via Aspose.Cells APIs.

3

Hi @Amjad_Sahi,

I have attached my excel sample on the post already, but for your reference here it is again.
AxisSample.zip (15.2 KB)

4

@rmacero,

I checked your file by opening the file into MS Excel manually but both axis values of pivot chart are the same. I actually asked you to provide an Excel file containing your desired chart which has different primary and secondary axis values on pivot chart. Please note, if you could not accomplish the task in MS Excel manually, Aspose.Cells cannot do that as well.