Calculated Series Properties Dialog Box, Axes and Chart Area
Select Axes and Chart Area on the Calculated Series Properties dialog box to define the categories and values on the x- and y-axes.
Options
Category axis
Select whether you want the series to be displayed on the primary or secondary categorical axis.Value axis
Select whether you want the series to be displayed on the primary or secondary value axis.Chart area
Select the chart area where the series will be displayed.