| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Large variation in series values
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Large variation in series values
In article ,
says... 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Large variation in series values
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... "Tushar Mehta" wrote: In article , says... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| Different error bar values within a data series? | Charts and Charting in Excel | |||
| multiple series of values graphed with indep. x values -possible? | Charts and Charting in Excel | |||
| Chart -- How to chart 65536 values in 1 series? | About this forum | |||
| Quasi Transpose / Stacking Columns | Excel Worksheet Functions | |||
Linear Mode
