I am running Excel2000. I have a chart of type "Line - Column on 2 axes". I wish to annotate the chart with Y axis grid lines (horizontal grid lines) associated with the 2nd (right side) Y axis. Y axis grid lines associated with the left Y axis is quite straightforward, but the right side axis seems to not support grid lines. Is there a way to do this? Reversing the Y axes is not a good solution as the chart format and axes "meanings" is somewhat standardized.

These charts are generated via VBA so a "VBA-only" solution is fine.

Thanks