Yes it is tough to introduce 3 different chart types into a single axis area.
Could you perhaps use reference lines (at cell level) in place of either the shape or line?
Thanks for your replay
actually I am not sure if it can help me as the Purpose of the line chart is to present a kind of a trend
and the shape is defined per a logic of the current status and target .
if you have more details to what your idea is or a visualize it will be
great ( I have attached a twbx in the
first post as an example)
thanks again maayan
If the shape is relating to a target then how about something like this?
Instead of the shape you use a reference line however you double emphasise the points which are below target by adding colour.
Column line and shape.twbx 536.4 KB
Thanks I am looking into it as unfortunately most of the bar will be red it can be hectic to the eyes .
I am considering removing the line and use symbol in calculated filed as a shape in dual axis