I have a two-column stacked chart -- the right-hand column represents a
blowup detail of one of the stacks on the left hand column. I can make a
PivotChart (or a regular chart) that displays all the data on a primary Y
axis, but whenever I choose one data point in the right-hand column to define
on a secondary axis, the other fields disappear. I want to select all four
stacked data points on the right-hand column and change them to a secondary
axis, and I cannot select multiple data points at once. Help!