I am trying to create a second axis on a pivot table, but it doesn't seem to
retain this format when I save the file or chose another category in the
pivot table to view. The method I am using to set the second axis is to
right click on the data series, chose format data series, on choose second
axis on the axis tab.