• I think I understand what you're doing. It sounds like you're trying to use some kind of grouping on states on the X axis... but the design sounds really odd. It would make sense if the X-axis was a time series or something like that, but as discrete values (Country,State) {(x,1),(x,2),(x,3),(y,1),(y,2)...}.

    Makes a LOT more sense as a bar chart. My guess is that you might be able to use a trendline or something similar, but since the groups are discrete, it doesn't really make sense.