chart value formatting

[Former Member]

Hi all,

I want to format the chart value. There is a chart which is bar-line chart. From chart properties, when i check the "show values" option the value of both bar and line is shown.

The chart contain two bars and three lines. Among three lines, two lines show negative value. While showing these two lines the value of these lines are shown just on markers of the line.

Some times these negative values are not clear as these are on markers.

Is there any way to show the value of the line below the markers of the line of a bar-line chart.

thanks in advance

[Former Member]

hi,

As there is no option/setting which will control the position of display of values w.r.t data marker,

One way to highlight the values when overlappng with data markers is to use background color.

Also, border can be used.

Data -> values -> Background Color.

Regards,

Vamsee