G
Guest
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.
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.