Large variation in series values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
 
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...
 
Back
Top