bar chart

[#1]

I have show trendline in a Bar chart.

For eg:

The total no of students in 3 class for the 3 years. i need to joint the max value for each class through a line.. basically showing the trend for consecutive years.

But the trendline is not showing in correct way .

Please somebody can help 😞

[#2]

Please find the eg attached ..

please refer to second tab .. i have taken it to be a combo chart still line is disabled.

[#3]

Hi

I think you have attached the wrong one, this one is completely empty and doesn't have a second tab!

[#4]

Ahhh I am sorry ..

Please find the correct eg attached

[#5]

Hi

Can you try the attached & let me know if that's what you want.

I changed the chart type on the General tab to Combo, then made the Only(QA) expression a line type.

Cheers,

[#6]

Thanks alot Nigel,

Even i selected the combo chart in first general tab .

Anyways i wanted the line to touch the top of each bar . taking QA it should pass from the top of blue bars . i got the same chart whe i was trying earlier with combo charts . i added three exp for line which joined the QA , UAT and SIT bars for different values on X axis but it returned me worong trendline

[#7]

Medha

Can you send me a JPG image of what you expect to see, I'm a little confused about your requirements.

Thanks,

[amit_shetty78]

I don't think it will be possible to have a line joining the top of each bar when there are more than 1 bar in a group. The line will place the line point in the center of the bar group.

Like here you have 3 bars, so the only line that will be possible to be touching the top of the bars is for the middle bar UAT. For the other 2 it would show the line points on the UAT bar.

If you have only one bar then you can get the line how you want it.

If you can send us a sample output that you are trying to achieve, may be in excel if its possible of an image.

[#9]

Hi Amit ,

Please find the screenshot attached ..