Calculated Series Properties Dialog Box, Axes and Chart Area
Select Axes and Chart Area on the CalculatedSeries Properties dialog box to define the categories and values on the x- and y-axes. For an introduction to the value and category axes, see Working with Chart Data Regions.
Select whether you want the series to be displayed on the primary or secondary categorical axis.
Select whether you want the series to be displayed on the primary or secondary value axis.
Select the chart area where the series will be displayed.