I am using Mac Excel 2016, and I am having an issue converting a table to a char

Question

I am using Mac Excel 2016, and I am having an issue converting a table to a chart, specifically with the x axis labeling. The x values in the table are 1995-2015, and for some reason the horizontal x axis on the chart is converting to 1-20, instead of the actual years. I have included a picture to clarify my problem. I need the x axis to be 1995, 1996, 1997, and so on. Thanks for any help or suggestions. I have tried everything and nothing seems to work.

S&P; 400 Midcap 33.50%) 28.60% 26.00%) 17.30% 22.60%) 30.40% 16.10%) 17.70% 25.20%) 13.40% -6.20%) 16.20% 1 .60% 16.80%| -15.50% 25.30%) 34.00% 3.20% | 15.20% -0.60%) 11.30% 16.30%) 8.90% 6.70% 33.90% -37.30% 18.80%) 35.00% 11.00%) 24.90% 5.50%) -3.10% 7.30%) 16.10% 26.50%) 31.60% 9.70%) 9.40% %| -1.37% DJIA 1995 1996 1997 998 1999 2000 2001 COMPARISON ON RETURNS DJIA S&P; 400 Midcap 7.10% 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 6.40%) EARS IS 1995 AND SO ON) 13

Explanation / Answer

to get the years at the x-axis you must remove the heading 4) of the column in which years are present and then try to insert the chart again. This will put 1995, 1996 etc., on the x-axis instead of 1,2,3...

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.