Huge Data Range- How Can I Create Different Axis

[cyberstven]

Hey everyone. I have just started working at an advertising firm trying to make a bar graph that shows multiple aspects of different campaigns. I want to show how many times the advertisement was shown, how many of those people bought the product and the percentage (how many people bought the product/ how many times the advertisement was shown). The problem is that one data set goes up to the millions, the other goes to the thousands and the other is a small percentage. Do you guys have any idea how I can neatly show this on a graph? Ill give you some examples of my data.


Campaign 1: Shown 287,508 times, 2283 bought the product, .00794 (or .7%) .
Campaign 2: Shown 1,463,215 times, 1304 bought the product, .00089 (or .08%)

Any help would be much appreciated! Thanks so much!

[cyberstven]

Also, while I'm at it. When I have been graphing my charts, it put the bars in the order of my data. Is there a way to sort it so the bars go biggest to smallest or smallest to biggest? Thanks again all

[Andy Pope]

You need to sort the data as charts don't do that.

Seeing as you have 3 different scales in that data you might consider a panel chart.

http://processtrends.com/pg_charts_panel_dot_plot.htm