Actual & Target Combo Chart with Competitor's Data
Hi,
I am looking to do up a combo chart with 6 expressions. The 6 expressions are: 1) Company actual data (bar) 2) Company target data (line & symbol) 3) Competitor 1 data (bar) 4) Competitor 2 data (bar) 5) Competitor 3 data (bar) 6) Competitor 4 data (bar)
As both expression 1 and 2 (company actual and target) are related, I need the symbol for target to appear with the bar for actual.
Here is an image of how I need it to look. Is this something that can be done?