I want to plot on the same Grafana dashboard today's (now) hourly average value against yesterday's hourly value to compare behaviour now vs behaviour yesterday at the same time (overlaid on current real-time telemetry.

The SQL query is working fine, will chart it as real-time (line), today's average (bar) and yesterday's average (line).

Real time, average (line), historical average (bar)

If I plot the third series as points, works fine:

Real time, average (bar), historical average (point)

If I set the second averages series to bars in the overrides, both sets of bars are reduced to single lines, at the same or any otehr zoom level.

Both averages as bars

3 hr zoom

This happens as soon as I set the override for the second (averages) series as bars.

I can do all three series as points, lines and bars in any combination and it works fine, unless I do two as bars.

I can see multiple examples online of people with two or more bars plus lines on a dashboard, and nothing in the documentation to suggest this is not possible.