Combo Chart values displaying incorrectly

[DanielleW1]

Hi all,

I am having an issue with the data values on a combo chart displaying on top of each other.

The chart consists of bars and lines, but some data points are falling at a similar value, meaning the values are displaying overlapping.

Has anybody any ideas how to get around this issue?

Thanks

Settings are as below:

[sergio0592]

Hi,

You can use dual() function for create a lag with your date point values.With Space ASCII or return carriage ASCII. eg

=dual(chr(32)&chr(32)&sum(Sales),sum(Sales))

[DanielleW1]

Thanks for the response.

I'm afraid this doesn't change the labels which are displayed on the chart when I do this.

The text still sits in the same place even when added spaces or return carriages to the expression

[sergio0592]

It works in QV. Maybe different behaviour on Sense.

[Or]

Probably not the response you're looking for, but from a visualization perspective, it's not a great idea to have multiple values on a chart in the first place. If you strictly need the numeric values to be displayed, consider using a table or pivot table (possibly with mini charts included for a visual perspective) instead.