I'm having a heck of a time trying to figure this out but I want to make a bar graph that shows unit price and units sold over a given time. Here is an example of my data
Year Qty Unit Cost
2005 10 $10,000
2006 30 $8,000
2007 50 $7,000
2008 100 $6,000
2009 250 $4,500
Basically I want two bars on my graph for each year. I want the Qty and the Cost as they pertain to each year to be side by side with the year label being the bottom axis. I have no problem doing this if the numbers are similar in value. Unfortunately the cost number is so large that the quantity numbers on my graph show up as almost nothing.
Year Qty Unit Cost
2005 10 $10,000
2006 30 $8,000
2007 50 $7,000
2008 100 $6,000
2009 250 $4,500
Basically I want two bars on my graph for each year. I want the Qty and the Cost as they pertain to each year to be side by side with the year label being the bottom axis. I have no problem doing this if the numbers are similar in value. Unfortunately the cost number is so large that the quantity numbers on my graph show up as almost nothing.
