graph drastically different values

[byerssha]

I want to create a graph to show possible relationships between sets of data that have very different quantities, for example, US population (in the hundreds of thousands) and other data sets with values that may range from 0 to 100 (call this one B), and another with a range of 1000 to 50000 (call this one C). The horizontal axis is the years.

What I want to wind up with is a visual (I'm thinking a line graph) that shows trends of multiple data sets over the same multi-year period.

I've found the setting that allows Format Data Series - Primary and Secondary Axis - but my data has more than two axes.

Can this be done with Excel 2007? Thanks.

 

[Claymationator]

Take a look at this link, I think that is what you are looking for.

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Hope that helps.

 

[RalphA]

Another possibility: use logarithmic scales.

 

[Gerald Higgins]

Another possibility - use indexes / indices.
Use formulas to convert your data so that for one particular year (suggest the first year but it doesn't have to be the first), all series evaluate to 100.

 

[PaddyD]

another option - use excel's statistical functions to do this empirically rather than by visual inspection of charts:

http://www.tushar-mehta.com/publish_train/data_analysis/16.htm