Purpose:
This function changes axes for all series in a single XY plot, while preserving the format of a chart.
It is useful for generating multiple high-quality plots with complex formatting, especially when there are a large number of series.

For example, the formatting of the XY charts follows Excel’s default settings, which might be unsatisfactory.
In the following, series 1 uses blue diamonds, series 2 uses pink squares, and series 3 uses yellow triangles, etc. You may want to change the colors or the shapes

Start:
Format the diagram as you want. This is your template.

Step 1:
We suggest that you copy the template to other place inside this workbook.
(The ChangeXY function does not work if a chart contains data from other workbooks.)

Step 2:
Select the diagram Click the PetroPlot --> ChangeXY button.

Step 3:
Change the X or (and) Y axes.
This example changes X axis.


This example changes Y axis.

Step 4:
Click the "Next" button.

Step 5:
The scale of new plot needs to be manually adjusted.

Result: