View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Max[_3_] Max[_3_] is offline
external usenet poster
 
Posts: 4
Default Dual axis on PivotChart

On Dec 16, 5:34*pm, Luke M wrote:
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!*

I must be missing something somewhere. My data is dollar amounts and
number of deals. When I drag it to the "Drop Series Here" I get a list
of all the dollar amounts (and numbers) listed there, and nothing on
the chart....

Thank you.