HOw to show a dot at all curves in line chart and want to show a line that show the trend from first value to last value.

[nikhilgarg]

HEy,

I have used a line chart but want to show a dot at all curves and want to show a line that show the trend from first value to last value. As attached in image. How can i show that ??

Thanks

[sasikanth]

Hi

Use Trend Lines or Reference lines

[nikhilgarg]

where to find trend or reference lines and how to use it ??

[sasikanth]

In Expression tab -- you will find Trend lines --

Predifines lines i.e Average , Linier etc..

In Presentation tab - Reference lines option is there

there you have to Add your own exp then it will display the line in chart

[ashfaq_haseeb]

Hi,

Make sure highlighted is selected.

Have a look at attached image.

Regards

ASHFAQ

[nikhilgarg]

HEy,

Thanks but trends lines doesnot touch first value and last value ?? Does it really show the trend of values ??

[#7]

[sasikanth]

Go for linier Trend line it will touch both

[nikhilgarg]

Hey,Can not we show the dots with different color ??

And i have attached a image in that , trend lines(polynomial) are used but they are not showing correct trend. How to get correct trend ??

[nikhilgarg]

Hey,Can not we show the dots with different color ??

And i have attached a image in that , trend lines(polynomial) are used but they are not showing correct trend. How to get correct trend ??