Graphing non numeric data excel

My horizontal axis would be Q1 Q2 Q3 Q4 and. I am trying to graph a large data set in Microsoft Excel 2010 and I am receiving an Input Error- Non-Numeric data and the data set will not graph.

Best Excel Tutorial Yes No Chart With Non Numeric Data

Ad Explore Different Types of Data Visualizations and Learn Tips Tricks to Maximize Impact.

. While clicking the new series select the Sign in the top right of the graph. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy Safety How YouTube works Test new features Press Copyright Contact us Creators. Learn More About Different Chart and Graph Types With Tableaus Free Whitepaper.

If the cells are truly empty ie no value no formula no nothing Excel will not plot those cells. Make sure there is just. Determine how much of each category there are to find the height of each bar in our graph.

Posted by 6 years ago. Mar 18 2008. Hello all Im attempting to make a 2-D Line Graph based on non-numerical data to show increasedecrease over a 4 period data of time.

Click on Arrow and click Left. So your best bet would be to simply select those cells and hit. You cant graph non numerical data but you can convert it to numbers eg by counting each of the responses as has already been done.

Identify the different categories for which we are creating a graph. Column Month repeats the data from the column Birthday and has the format mmm to show just a month name. TEXT mmm Column Number has the number 1 one.

Attach a sample workbook. What do I need to do with the. Double click on each Y Axis line type in the.

Hi Im smarter than this - seriously - but for whatever. In your Pivot Table use the monthswords as row fields and use Count. Creating a chart using non numerical data.

Best Excel Tutorial Yes No Chart With Non Numeric Data