Trend Line chart in a Pivot table

[#1]

Hi,

Can we create a TREND LINE / CHART in a column based on month data into a pivot table? Below is the sample data. In column G I want to add a trend line showing the performance of the actual vs target. please advise if this is possible?

thanks

Sowjanya

[Anil_Babu_Samineni]

That may possible?

Steps followed

1) Go to G expression

2) There you will get Display options and choose Mini chart

3) go to mini chart settings - Dimension is month and click ok and ok and check

HTH

Anil

[Kushal_Chawda]

see this

Straight Table - Calculate Mini Chart Trend