Line Chart Axis Help

[melfricke]

My chart designed to compare impressions to clicks, is impossible due to the difference between the impressions and clicks. My impressions are very high at around 100,000 and my clicks are around 1,000.

My question is that is there a chart or a setting that will allow me to expand or stretch out the lower portion of the axis so that those numbers aren't so scrunched into the bottom of the chart. I've seen a good example of this in Google Trends charts. My last search for QR Codes provided me the chart of my dreams.

Any chance I can make this happen?

[teylyn]

Hello,

assuming your chart has two data series, one for impressions and one for clicks, select one of the series in the chart, open the format dialog for the series and click "Secondary Axis". You will then see another Y axis to the right of the chart, where a different scale shows the numbers for that series.

cheers,