categorical data

Good Morning Fellow Excel Experts, Per usual - a thanks to everyone who contributes to this forum! What would the macro be to sort on column A / row 1 (Last Name, First Name), data through [column B:column Q] then find that same name in multiple worksheets (tabs) and then place that same name...

Good Morning All, As always, I must start out my posts with a big thank you to everyone who contributes to this forum. So I have a bunch of data in various columns with only one column I need to convert to categorical data. Column H is what I will need the script to focus on. I have a...

Hello all. I am an architect and I am trying to develop a code in excel for organizing our projects. So far I have a workbook with two tabs. Sheet1 is called "Entry", Sheet2 is called "NumericalOrder", Sheet3 is called "Alphabetical Order", and Sheet 4 is called "Civil". The headers on the...

Hi everyone, I have a set of academic scores data that categorized into grades A (>85), B(>70), C (>55), D (>40), E (40 and below). Any idea how could I plot a chart in Excel (perhaps line chart with marks?) showing the grades but not the actual score values? I am using Excel 2010. Test No. ||...

Quick Rundown: I have a Purchase Order template into which I type Product Codes. The template uses lots of lookup functions to populate the rest of the fields such as Item Description, Vendor, Price, Item Number, Type, etc. from an equipment database. It also automatically sums all prices in the...

Okay, so I have a really simple but confusing question. I have this chart which shows the percentage of tickets that are late and on time by the User Role. The problem is, I only want to show the "OnTime" percentages and remove the "Late" category from the x-axis. I'm having trouble because my...

hi, i was wondering if it is possible to plot categorical data on the Y axis and contiuous on the X axis in excel. what i am trying to achieve is as follow (BTW, I know i can do this in reverse, but i need the categorical data on the Y axis). as an example, my 4 y axis variables have the...