I created a pivot table that contains data in the following format:

Year | Month | Data 1
Data 2
Year | Month | Data 1
Data 2
etc.

Now, I am trying to create a chart where Data1 and Data2 would be on 2
different y axis (Data1 is an average dollar amount and Data2 is the
number of deals, so they don't work well on the same Y-Axis).
Is there a way do to this?
When I create the chart both number (data1 and Data2) appear to be
just one series, and when I right click on it, the Secondary Axis is
grayed out).

Thank you,
Max