Question: How do I move the trendline higher so it doesn't touch the bar graph and the number aren't on top of each other? = ?
How do I move the trendline higher so it doesn't touch the bar graph and the number aren't on top of each other?

= ? x Jack Stephens : I J AA AB 2016 21.2 6.2 6.2 2017 22 6.1! 6.1 14 15 16 > 27.1 17 18 19 19.7 20.3 20.1 20.3 20.5 x5 Book2 - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER * Cut > Calibri - 11 AA Wrap Text General AutoSum - A EE Copy FA Z H Fill - Paste BIU 4.0 .00 $ % Merge & Center - Conditional Format as Cell Format Painter Insert Delete Format Sort & Find & .00 0 Formatting Table Styles Clear Filter - Select - Clipboard Font Alignment Number Styles Cells Editing M24 X E F G H K L M N 0 P Q R S T v w X Y Z 15 16 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 17 Brazilian 11 11.5 12.2 12.7 13.2 13.6 14 13.7 14.9 -------- 15.5 16.3 17.1 17.7 18.4 19.1 19.7 20.3 20.1 20.3 --- 20.5 -- 18 consumpt 4.2 4.3 4.5 4.7 4.8 4.9 4.8 4.7 5 5.1 5.3 5.5 5.6 5.8 6 6.1 6.2 6.4 6.4 6.2 19 consumpt 4.2 4.3 4.5 4.7 4.8 4.9 4.8 4.7 5 5.1 5.3 5.5 5.6 5.8 6 6.1 6.2 6.4 6.4 6.2 20 21 22 23 24 25 26 27 25 7 6.4 6.4 28 6.2 6.2 1 29 21.2 6 30 20 19.1 31 4.9 17.7 32 5 15.5 33 14.9 14 34 13.7 4 35 36 3 37 10 38 39 2 2 40 5 41 1 42 43 0 0 44 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 45 Brazilian consumption 46 consumption per capita 47 6 6.1 6.2 5.8 55 55 5.3 5 5.1 4.8 4.8 4.7 42 4.3 15 13.6 12.7 13.2 12.2 11.5 Sheet1 + Select destination and press ENTER or choose Paste 3 + 91% Start mm 7:27 PM 6/13/2020 = ? x Jack Stephens : I J AA AB 2016 21.2 6.2 6.2 2017 22 6.1! 6.1 14 15 16 > 27.1 17 18 19 19.7 20.3 20.1 20.3 20.5 x5 Book2 - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER * Cut > Calibri - 11 AA Wrap Text General AutoSum - A EE Copy FA Z H Fill - Paste BIU 4.0 .00 $ % Merge & Center - Conditional Format as Cell Format Painter Insert Delete Format Sort & Find & .00 0 Formatting Table Styles Clear Filter - Select - Clipboard Font Alignment Number Styles Cells Editing M24 X E F G H K L M N 0 P Q R S T v w X Y Z 15 16 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 17 Brazilian 11 11.5 12.2 12.7 13.2 13.6 14 13.7 14.9 -------- 15.5 16.3 17.1 17.7 18.4 19.1 19.7 20.3 20.1 20.3 --- 20.5 -- 18 consumpt 4.2 4.3 4.5 4.7 4.8 4.9 4.8 4.7 5 5.1 5.3 5.5 5.6 5.8 6 6.1 6.2 6.4 6.4 6.2 19 consumpt 4.2 4.3 4.5 4.7 4.8 4.9 4.8 4.7 5 5.1 5.3 5.5 5.6 5.8 6 6.1 6.2 6.4 6.4 6.2 20 21 22 23 24 25 26 27 25 7 6.4 6.4 28 6.2 6.2 1 29 21.2 6 30 20 19.1 31 4.9 17.7 32 5 15.5 33 14.9 14 34 13.7 4 35 36 3 37 10 38 39 2 2 40 5 41 1 42 43 0 0 44 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 45 Brazilian consumption 46 consumption per capita 47 6 6.1 6.2 5.8 55 55 5.3 5 5.1 4.8 4.8 4.7 42 4.3 15 13.6 12.7 13.2 12.2 11.5 Sheet1 + Select destination and press ENTER or choose Paste 3 + 91% Start mm 7:27 PM 6/13/2020
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
