We help IT Professionals succeed at work.

Pivot chart with a secondary Y axis

sofiabas
sofiabas used Ask the Experts™
on
Is it possible to create a Pivot chart with a secondary Y axis?
Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Yes, certainly. Create the pivot chart like usual, then right-click on the series that needs the secondary Y-axis. Choose "Format Data Series", then choose "Secondary Axis" on the "Series Options" tab.