Might be easier to explain this working with the actual chart.

Grab your data buttons and drag them to where it says "Drop Series fields
here"
You should now have 2 series instead of one. Change type of chart to line
what you want, then double-click one of the series and change axis to
secondary axis.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Max" wrote:

Thanks.
But how do I get them to be Column headers? I add both data1 and data2
to the "data" area of the pivot chart, and that is how it gets
arranged there (as row headers, not columns).

Thank you for your help.

On Dec 15, 11:44 pm, Luke M wrote:
To get more than 1 series, Data1 and Data2 need to be column headers, not row
headers. You should then be able to do a secondary axis.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*