Hi,
I'm trying to create a combination chart in some ways.
I have data that looks like the following:
Country 2013 2014 Historical Average
Canada 8 9 8
US 4 6 7
Portugal 5 7 2
Spain 4 5 3
Brazil 7 8 6
Australia 9 10 9
India 4 5 7
China 3 4 4
Japan 7 8 7
I'm trying to create a clustered bar chart where the bars run horizontally and the historical average shows as a symbol on the chart instead of another bar.
I've tried selecting the series and adding as scatter plot but then the points aren't aligned correctly. I have Excel 2013. The attached excel file shows what I want the graph to look like where I've modified the error bar to show the symbol, but I'd like to customize the symbol if possible.
Bookmarks