Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have one straight table from which i want to create the line chart.to calculate the final expression - LR i have to do some calculation on the runtime of the chart by using the ABOVE function in the chart.
| Year | Duration | LR | AP | AAP | ALH | ANP | PC | APC | IBNR | DLR | AIC | NR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 | 1 | 115.72% | $25293757 | $2235403 | $66828 | $22991526 | $1393253 | $1393253 | $12371726 | $13203090 | $26968069 | ($3976543) |
| 2004 | 2 | 100.07% | $26677325 | $2357680 | $70483 | $24249162 | $5004874 | $6474338 | $0 | $17792832 | $24267170 | ($18008) |
| 2004 | 3 | 84.40% | $28197933 | $2492067 | $74501 | $25631365 | $2724470 | $9567845 | $0 | $11663490 | $21231335 | $4400030 |
| 2004 | 4 | 77.12% | $29607829 | $2616671 | $78226 | $26912933 | $1276331 | $11322568 | $0 | $8814999 | $20137567 | $6775366 |
| 2004 | 5 | 51.34% | $31088221 | $2747504 | $82137 | $28258580 | $1240823 | $13129520 | $0 | $0 | $13129520 | $15129060 |
| 2005 | 1 | 112.56% | $22228561 | $1991560 | $78322 | $20158679 | $1695365 | $1695365 | $9308905 | $11946377 | $22950647 | ($2791968) |
| 2005 | 2 | 110.19% | $23495589 | $2105079 | $82787 | $21307724 | $4930039 | $6722039 | $0 | $16978791 | $23700831 | ($2393107) |
| 2005 | 3 | 92.80% | $24670369 | $2210333 | $86926 | $22373110 | $2611111 | $9669252 | $0 | $10928738 | $20597990 | $1775120 |
| 2005 | 4 | 53.98% | $25903887 | $2320850 | $91272 | $23491766 | $1418120 | $11570835 | $0 | $0 | $11570835 | $11920931 |
| 2006 | 1 | 120.12% | $19176449 | $1707283 | $48358 | $17420809 | $1315087 | $1315087 | $8515292 | $11448393 | $21278772 | ($3857963) |
| 2006 | 2 | 102.07% | $20135271 | $1792647 | $50775 | $18291849 | $3888619 | $5269460 | $0 | $13439505 | $18708965 | ($417116) |
| 2006 | 3 | 45.21% | $21142035 | $1882279 | $53314 | $19206441 | $2088876 | $7621809 | $0 | $0 | $7621809 | $11584633 |
| 2007 | 1 | 116.53% | $19611670 | $1662647 | $40622 | $17908401 | $1202305 | $1202305 | $9272103 | $10676155 | $21150564 | ($3242163) |
| 2007 | 2 | 33.34% | $20592254 | $1745779 | $42654 | $18803822 | $3813695 | $5076115 | $0 | $0 | $5076115 | $13727706 |
| 2008 | 1 | 48.23% | $21339309 | $1821722 | $39090 | $19478498 | $1306508 | $1306508 | $7124344 | $0 | $8430852 | $11047646 |
I want the final result to look like the one below but I dont want the columns after LR i.e AP, AAP etc but those are required to calculate the LR.I tried doing the invisible and un checking the symbol and line on display options but it is not working
Any one has worked on these charts before or any ideas, suggestion
Thanks for all the help and really appreciated
Talha