I'm trying to make a column chart with two vertical axes. I can get the second vertical axis to show but I can't make it so that the bars don't overlap such that they appear next to one another. I tried to use the information from one of the other questions posted, but that's not working the way I expected. Here's what my data look like:
|Industry||Avg. Weekly Wage||% of State AWW|
|Natural Resources & Mining||$1,402||173.7%|
|Trade, Transport., & Utilities||$700||86.7%|
|Prof. & Bus. Services||$860||106.6%|
|Education & Health Svcs.||$729||90.3%|
|Leisure & Hospitality||$318||39.4%|
I want industry to appear on the horizontal axis, currency to appear on the left vertical axis, and percent to appear on the right vertical axis. Then I want the bars for the average weekly wage and the % of state average weekly wage to be next to each other rather than overlapping. Any suggestions for making this happen would be greatly appreciated.