Currently it is only possible to add a line in a bar chart which is shown over the full width. It would be nice to be able to draw a line in/at every bar. The the height of the line can be set with an expression.
Examples:
I've a stacked bar with the number of sales and the expected number of sales stacked for different regions. For every region I would like to add a line in the bar chart at the height of the target for that region.
Indeed, I want to visualize the target in the related bar. A side by side bar isn't feasible when for example I use a color for different months while the target is on a yearly bases. This is also a reason why a combination chart doesn't work, since then it is not possible to color by month. So I want to use this in a bar chart since they are more flexible than the line charts.
Wim and Andrew, to make sure I understand this correctly: you would like to visualize for example sales vs target per product category, and instead of using side by side bars in a barchart you would like to visualize the target per category as a line?
I assume you considered (and possibly ruled out?) using a combination chart? I have heard what I think is a similar request which is expressed as "visualize sales vs targets" in a combination chart with the target shown as a dot or other symbol instead of a full connected line.
yes the ability to set a horizontal line based upon an expression for each unique category value in a bar chart would be great - we don't usually apply a single target (horzontal line) across all of our unique category values.