is it possible to create a chart like this? Bar for actual, line per bar (or formatted point) for last period.
Probably you could use combo chart. Attached example.
There is no chart option like the one you showed. But we can create a combo chart to show bar and line.
This may be what you need
Bullet charts (well sort of) using a stack chart
Retrieving data ...