Chart with Actuals and Goals for Multiple INTL Regions
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!!!
|