Combination of bar and line in graph: Circle of line graph should be on center of Bar

[Former Member]

I found a way to combine bar and line in the same graph. But I want circle(dot) of line to be on the center of each bar.. Right now the circle of the line sits on the right edge of the bar but not in the center of the bar.

Thanks in advance for any help on the above issue.

Manjunath N Jogin

[Former Member]

Hi Manjunatahan,

One way of displaying the connector lines at the center of the bar is as follows:-

On the bar graph, click on any one of the bars and select it, so that it borders gets highlighted. Now right click on it and select 'Trendlines'. From the 'Available Types', select 'Connected Line' and drag it to the adjoining text box. Click on 'OK'. When you will preview the report, the lines would be placed on the centre of the bar, as required.

Thanks,

Alok.