Plotting With Words On Vertical And Horizontal Axis
Apr 29, 2014
I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?
I have a data set that is a spectrum of (y)intensity vs (x)energy I was wanting to add an additional X axis at the top of the graph showing the wavelength conversion for the energy value, is that possible in excel? and if so how?
There is probably a really simple solution to this, but I have a column 'A' of data, with various numbers, and a column of data 'B' with letters from A to Z. However when I try and plot this on a scatter graph, the x axis uses numbers rather than letters, with data points all over the place?? I'd like the X axis to have the letters A to Z, and the data to stack up vertically when there is a few different numbers correpdoing to 1 letter. Specifically, a scatter graph
I have a need to present 2 sets of values on the Y ( vertical ) axis but the Scales differ appreciably. I 'd like to know how can I present these so that I can appreciate the changes in both these values.
E.g. X fn of A B ( Y axis )
When I plot X against A & B because B has a HUGE range , variations in A appear minuscule. How can I address this scaling problem so that pictorially I can appreciate both changes in A and B against X.
Is there is Way to Plot A and B on different Y axis like one is on the LHS Y axis and other one on the RHS Y axis . This is a PIVOT chart using data from another worksheet.
I was wondering if it's possible to create a macro that would check the range horizontally and vertically and return the resoults in a userform so that when workbook is open this userform would come up with the information who is due for refresher....
The sample book doesn't show the real size of the original matrix which has 190 employess and about 30 procedures so as you can imagine it's a pain.. to keep it up to date so I need something to flag that for me, yes I can see the red cells but still there's so many cells that I might easly miss some of them....
I've been working on this for days, i still got no solution on what formulas I will put on cells in "To" tab. The excel file is composed of two tabs "To" and "From". We will convert the "From Tab" to "To" format. What formula will I put in D3 to V3 and drag down in "To" tab to convert datas from "From" tab.
I have to fill an invoice template, whereby I need to lookup the unit price in a pricing sheet, based on the effective date (horizontally placed) and the specific tasks to be invoiced (vertically placed).
The effective date cell (B1) is the one that can be changed, the formulas in the unit price cells (yellow highlighted) then needs to look up the price for that specific task in the table on the tab "pricing sheet".
I was trying something with INDEX / MATCH, but can't get it to work.
I have a problem that lookup vertical and horizontal corresponding values when there was duplicate values as it's only returning the first value found. What I want was to lookup the vertical and horizontal corresponding values on the left most & top most column based on the largest values column and also to return the duplicate values under the vertical and horizontal value column in ascending order if it's a duplicate values.
E.g. for "Shop1", what's the value for segment "PI" and product "Credit", etc.
An example file attached : fz73m5zEmZS6Y14-C.xlsx
The key thing for me is to do this WITHOUT changing data structure, because that really would be a huge pain. I mean, if it's no possible to do without changes (e.g. adding an extra column, etc.), I'll have to live with that I guess. But ideally I would really like to avoid changing data structure.
I have a huge data table, and I just can't seem to find a way to sum the numbers the way I want.
Here's an example of the table:
___ A B C A B C A B C A B C A B C Jan 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 Jan 3 4 5 6 3 4 5 6 3 4 5 6 3 4 5 Jan 3 4 5 6 3 4 5 6 3 4 5 6 3 4 5 Jan 3 4 5 6 3 4 5 6 3 4 5 6 3 4 5 Feb 3 4 5 6 3 4 5 6 3 4 5 6 3 4 5 Feb 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 Feb 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 Feb 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 Feb 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 Mar 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 Mar 6 3 4 5 6 3 6 3 4 5 6 3 6 3 4 ... ...
But, in essence, I need to sum together every value that's in January AND is in a column labeled "A".
I could just write up a bunch of "sumif=" functions but I feel like there's a simpler way.. I tried using "sumifs=" but I don't think it can handle horizontal AND vertical criteria...
Year 1 Year 2 Income 100 150 Expense 20 30 Net Income 80 120
I need to take the calculated "Net Income values" and also place them vertically by themselves, like this:
Year 1 80 Year 2 120
I know I can copy and paste the values easily using the "paste special... transpose", but how can I easily do this so that it continues to reference the original values? So that if I change the Income in year 1 of 100 to 120 the vertical Year 1 value would change from 80 to 100?
I am trying to create a formula that will sum a range based on both horizontal and vertical criteria using the following data:
1 2
1 20% 25%
2 40% 25%
3 40% 50%
For example, if the horizontal criteria were "1" and the vertical criteria were "2", I need to sum the 20% and 40% amounts (60%). If the horizontal criteria were "2", and the vertical criteria were "3", I would need to sum the 25%, 25%, 50% (100%). I have tried using SUMIFS functions, but they do not appear to work with both horizontal and vertical axis criteria (I receive a #VALUE error).
I need a solution for the equivalent of a SUMIF combining both vertical and horizontal data. The vertical cells align to the horizontal ones, but they're in a different table.
My attempted formula is: =SUMIF($H$22:$H$30,"TRUE",D7:L7) *note that this is just an example set of data...my real data set is much larger (both rows and columns)
I need to be able to do this without transposing any of my data.
Things I've tried: - Another option I tried was making D7:L7 a named range and using the transpose function (as an array) within the SUMIF formula above. I received an error. - I tried using a bunch of IF statements added together (i.e. =IF(H22=TRUE,D7,0)+(H23=TRUE,E7,0)...); this actually works properly, but I get the "formula too long for cell" error when I put them all in (too many characters)
I need to transpose or move some of the data on Column B to horizontal position, is there a formula that I can use to do this? Attached is sample of what I want to do.