I am having trouble getting a Bar Graph. I have a sheet with 9 columns. A represents a city, B is the Percentage of visitors who made a purchase, and C is the Number of visitors. Columns B and C are repeated three more times. Each two columns represent a year (B/C = 2005, D/E = 2006, etc.)
How do I get a bar chart that will show two bars for each year. A blue one that will show the Percent Visited and a Red one showing Number Visited. This would be repeated three times so that each years has a two color bar, blue showing percent and red showing number. (Color can be anything I used blue/red for illustration.) I want to graph only one row.