Secondary axis columns disappearing

[Sreya612]

Hi,


I'm attempting to show some data in a simple column chart in Excel 2003.


I've got two data sets and whenever I format one to appear on a secondary y axis, the columns for that dataset disappear completely from the graph.


The second axis is still present and when I format the table, the scale adjusts itself as if the columns are still there but nothing is shown.


Can anyone advise me?


Many thanks.

 

[Sreya612]

This problem does not seem to arise if I use columns for one dataset and a line for the other. Only if I try to have two sets of column data.


Thanks.