Hi I am trying to create a graph like this:
Each vertical bar represent different cities on the big bar. I am not able to create this using dual axis.
Please post a sample workbook!
Here is the sample data. I am trying to plot the average of 'X' values, for each city in a state(filtered), as the small vertical bars (as seen in the pic in my original post) against the 100% bar.
Retrieving data ...