Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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