User Profile
ea0428
Copper Contributor
Joined Jul 13, 2022
User Widgets
Recent Discussions
Normal distribution graph with data shaded inside of it
I need help creating a bell curve (normal distribution chart) and shading the left side of the curve with data. Here's what it needs to look like Here's the data I need to be shaded -16.37% -11.99% -9.12% -15.59% -22.20% -22.51% -21.19% -3.15% -3.56% -4.41% -5.08%Combo Chart Line up
I am trying to line up this data and create a combo clustered chart with a scatter plot. Notice how the scatter plot does not exactly line up with the clustered column chart. S&P 500 Intra Year Declines Total Return 2002 -33.0% -22.10% 2003 -13.8% 28.67% 2004 -7.4% 10.88% 2005 -7.0% 4.91% 2006 -7.5% 13.91% 2007 -9.9% 5.68% 2008 -47.7% -37.00% 2009 -27.2% 26.45% 2010 -15.6% 15.06% 2011 -18.6% 2.11% 2012 -9.6% 14.22% 2013 -5.6% 32.37% 2014 -7.3% 13.67% 2015 -12.0% 1.37% 2016 -10.3% 11.95% 2017 -2.6% 20.79% 2018 -19.4% -5.19% 2019 -6.6% 31.47% 2020 -33.8% 18.39% 2021 -5.1% 28.68% 2022 -23.0% -19.97% Wondering if there is a possible way to simply line up the dotsIndex Match
I need to find a way to find a way to use index match or another lookup function to pull the 1st, 2nd, 3rd, 4th, 5th largest number from a data set based on a criteria. For example, I want to find the 2nd largest stock price if the asset class is equity. There are multiple asset classes so there is a column that contains whether the security is in equity, fixed income, etc. Thinking I need to use the LARGE function nested within an INDEX MATCH. Please help, I'm begging.
