Create Line Chart with Proper formatting
Should be formatted as shown in picture
Date Revenue'000
1990 ₹ 2,156
1991 ₹ 3,562
1992 ₹ 7,506
1993 ₹ 6,258
1994 ₹ 6,279
Revenue'000
1995 ₹ 1,963 ₹ 8,398 ₹ 8,418
1996 ₹ 6,736 ₹ 7,506
₹ 6,976
₹ 6,736
1997 ₹ 3,280 ₹ 6,258 ₹ 6,279
1998 ₹ 8,398 ₹ 4,686
1999 ₹ 2,882 ₹ 3,562
₹ 3,280
2000 ₹ 4,686 ₹ 2,882
₹ 2,156 ₹ 2,173 ₹ 2,166
₹ 1,963
2001 ₹ 6,976
2002 ₹ 2,173
2003 ₹ 2,166 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004
2004 ₹ 8,418
₹ 8,418
₹ 2,166
2003 2004
Create Combo Chart with Proper formatting Revenue'000 %
Should be formatted as shown in picture
$8,709
$10,000 1.2
$9,000 100%
93% 95% 1
Date Revenue'000 Running Total % $8,000 86% 89%
79%
2005 $528 $7,000
73% 0.8
$6,000 63%
2006 $4,550 5,078.00 7% 59%
$5,000 51% 0.6
2007 $8,189 13,267.00 17% 46%
$4,000
2008 $1,730 14,997.00 19% 35% 0.4
$3,000 26% 29%
2009 $5,262 20,259.00 26% $2,000 17% 19%
0.2
$528
2010 $2,172 22,431.00 29% $1,000 7%
2011 $4,384 26,815.00 35% $0 0
2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
2012 $8,709 35,524.00 46%
2013 $3,618 39,142.00 51%
2014 $6,372 45,514.00 59%
2015 $3,456 48,970.00 63%
2016 $7,478 56,448.00 73%
2017 $4,649 61,097.00 79%
2018 $5,831 66,928.00 86%
2019 $1,599 68,527.00 89%
2020 $3,695 72,222.00 93%
2021 $1,678 73,900.00 95%
2022 $3,490 77,390.00 100%
Total $77,390
1.2
100%
93% 95% 1
0.8
0.6
0.4
0.2
0
2020 2021 2022