How do I get two colums of data to chart next to each other when their vales
are very different, so the Y axis is only charting the bigger value. Ex.
Sales values in weeks 1 - 8 range from 50,000 - 100,000 and hours worked
range from 30 -50. I want to show the correlation on the line chart, but it
puts the hours worked data as a straight line at the bottom of the chart
because the values a re so low compared to the sales data.

Hi,

Select one of the series and on the Format dialog, CTRL+1, Axis tab set the
series to the secondary axis.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KenCanuck" wrote in message
...
How do I get two colums of data to chart next to each other when their
vales
are very different, so the Y axis is only charting the bigger value. Ex.
Sales values in weeks 1 - 8 range from 50,000 - 100,000 and hours worked
range from 30 -50. I want to show the correlation on the line chart, but
it
puts the hours worked data as a straight line at the bottom of the chart
because the values a re so low compared to the sales data.