Actual v Target Sales - Chart Visualization

[djb85 (Derek Byrne)]

Our team have Quarterly Sales targets and we’d like to visualise their progress towards their target, in a chart view. We can shape a board whatever way is needed to get this visual.

Something like this:

Currently we have a baseline and actual Sales on the Y-axis but this doesn’t display in numbers the gap between the Quarterly Target and Current Sales. So what we need on the Y-Axis is an overlay/stack of:
→ Sales
→ Formula: Target - Sales

I don’t believe this visualization and overlapping be doing natively in Monday.com but are their any marketplace apps that could provide this visual?

[lwatkins31 (Lee Watkins)]

If you wanted to visualise the difference between target and actual sales on a dashboard, you could create a number widget for each that corresponds to a formula (target minus actual sales). Not a chart, apologies, but I hope this gives you an option.

Similar concept to the numbers widgets above, but with Target, Actual Sales and the difference between the two indicated.