Target line and clustered bar chart with target

[sirmay]

Hello,

I am trying to create a chart as like;

Here I have 3 columns as:

1. Actuals

2. Actuals + In progress

3. Target

Target should be blue points. Actuals and Actuals+ In progress are clustered bar chart

When I am trying to create same chart with same type column, I create below one.

Firstly, target line should be only dots, I could not find a way to do that.

Second one, Y axis at right side should not exist. Because of it line chart is above of the clustered bar.

Could you please  help me with this one?

Regards,

[v-angzheng-msft]

Hi, @sirmay 

May I ask if your problem has been solved? The method provided by amitchandak is a good attempt. If it helps,  could you please mark the post which helps as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[amitchandak · Accepted solution]

@sirmay , for line  You can use the color as #FFFFFF00 or the same as background-color and use marker.

Switch of secondary axis (in Y-axis) , that will move like to primary axis