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.
|