Hello,



I am trying to build a chart that has the following as the X Axis: International / Atlantic / Pacific / Americas. For each region, I want to have 3 data sets - 2014 Actual, 2015 Actual, 2015 Goal. I would like 2014 Actual and 2015 Actual to be bars side by side, but the 2015 as a data point right above the 2015 Actual bar. I thought to start with all three as bars, and change the chart type of the 2015 Goal to a Line, but it places the data point between 2014 actual and 2015 Actual. Is there any way to change it so that the 2015 goal data point is directly above the 2015 Actual bar? I've attached my draft.

Really appreciate your help!!!

Attached Files

excel chart examples.xlsx (11.4 KB, 17 views)

Maybe something like the attached.

Attached Files

excelchart_2.xlsx (11.8 KB, 11 views)

Hi - I'd really like to get the dot that reflects the goal to be directly over the 2015 Actual (green bars) since that is the only data point that it is referring to. Right now it currently sits between the red and green bar. would love it to be above the green bar only

I can't help you with that one if you need to show both 2014 and 2015.
Maybe others have a solution?

Thank you for your assistance, appreciate it.