Large variation in series values

[QPapillon]

Good Morning,

I would like to display serie A (in millions) and serie B (in thousands) in
the same chart (preferably line). What is the best way to do this; because
of the millions in serie A, serie B line gets 'scrunched' to the bottom. Any
suggestions?

Thanks!
Carol

 

[Tushar Mehta]

Good Morning,

I would like to display serie A (in millions) and serie B (in thousands) in
the same chart (preferably line). What is the best way to do this; because
of the millions in serie A, serie B line gets 'scrunched' to the bottom. Any
suggestions?

Thanks!
Carol

Move one of them to the secondary axis. To do so, double-click that series,
then select the Axis tab. In there, select 'Secondary'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[QPapillon]

Sorry - I haven't used these tools that much - I can't seem to find where I'd
put that info in so as to see the article...