Presenting Data In Different Columns In A Graphic / Pivotgraphic?
Jul 24, 2013
how to present some data in a graphic or pivot table graphic.
I have 2 columns with a list of competitors (competitor 1 & competitor 2) involved in a negotiation + the price/value of the negotiation. Each line represents a negotiation with a value in numbers & the names of the 2 main competitors involved.
I have around 150 lines in the original file and would like to show in a graphic what are the competitors that we regularly find in the negotiations and what is the value of the negotiations they are involved.
The problem is that there is no main competitor so i can find the same name in any of the 2 columns and i cannot make separate graphs for each column because if i do so i duplicate the value.
Is there any way that aggregate this info into a single graphic/pivot graphic? Im using excel 2013
Attached my file with the example
View 4 Replies
ADVERTISEMENT
Jul 24, 2013
I have 2 columns with a list of competitors (competitor 1 & competitor 2) involved in a negotiation + the price/value of the negotiation. Each line represents a negotiation with a value in numbers & the names of the 2 main competitors involved.
I have around 150 lines in the original file and would like to show in a graphic what are the competitors that we regularly find in the negotiations and what is the value of the negotiations they are involved.
The problem is that there is no main competitor so i can find the same name in any of the 2 columns and i cannot make separate graphs for each column because if i do so i duplicate the value.
Is there any way that aggregate this info into a single graphic/pivot graphic? Im using excel 2013
View 2 Replies
View Related
Nov 5, 2008
I would like to present the data from Sheet 1 on Sheet 2 in a slightly different way.
I want to show, on Sheet 2, all of the projects in Phase A, Phase B, Phase C. So all of the projects in Phase A will be listed in Column A etc.
View 6 Replies
View Related
Jul 25, 2014
I've been asked to work out a way to easily present summarized data which, when so desired, should be able to go into deeper detail. The only way I know how to do this is via Pivot Table. The thing is, that simply adding the numbers doesn't make sense at all. The reason is that I'm working in share of market per country and simply averaging these shares doesn't make sense due to different market sizes in terms of absolute volumes. Hence different weights need to be given to each share. Allow me to illustrate: I'm interested in Belgium, the Netherlands & Luxembourg and their combined area, the BeNeLux. Each country sells products A - C. Adding the numbers per country is fine as that total amounts to the total company share for that country, but for the area it doesn't. So what I want to do is show the data as follows (see also attached screenshot):
BeNeLux
--------> Belgium
-----------------> Product A
-----------------> Product B
-----------------> Product C
--------> Netherlands
--------> Luxembourg
I want each click to go into further detail, but initially it would show only BeNeLux - only after clicking it would show each country separately and if needed, the products after another click. I have all the numbers such as share for the area but I can't seem to get it to show the right way.
ExcelHelp.jpg
ExcelHelp.xlsx
View 1 Replies
View Related
May 9, 2007
I have a list of bookings that have been made for class rooms, with columns such as persons name, start date, end date, class room. My task is to present this data in an alternative view, that is:
Dates along the top and classroom names down the left hand side, in the intersecting cells i need the persons name.
View 9 Replies
View Related
Nov 25, 2013
I got one excel document with a graphic that i want to be seen on a other excel document. But the data on that graphic must be able to mutate with the original excel document. It is just to function as a dashboard. How can i fix that.
View 1 Replies
View Related
Jan 3, 2012
I want to combine all data in a single graphic. It must be like a coordinate system.
The file is in that address: [URL] .......
View 1 Replies
View Related
Jul 24, 2009
Assume A1=25 and A2 = 35.
I typed, in cell A3: =A1+A2 which returns: 60.
Is there a way to present, in a single cell, instead of the formula references - something like: =25+35 as TEXT ?
(Any change in A1 and/or A2 will be reflected in the presentation of those two values
I checked some add-ins functions, like "MoreFunc" etc, and INDIRECT - but no results.
View 4 Replies
View Related
Jun 4, 2014
I would like to multiply a serie in 'series values' (before presenting on a chart) with a factor (in a formula like ='[1]name'!$V$2:$V$148)
in other words I would like to do something like
=('[1]name'!$V$2:$V$148)*50
but I don't seem to succeed with the correct syntax.
In Excel searching for "multiply series values" under "edit series" there is to read:
"Use this option to include additional data series on the chart or to modify the name and values of existing data series without affecting the data on the worksheet."
So what I want to do seems to be possible.
Excel 2007 version 12.0.6611.1000
I know I can create a temporary column with the multiplied values but THIS IS NOT the way I want to solve the problem.
View 6 Replies
View Related
Aug 9, 2007
I assume there isn't but like in HTML you can hotspot a graphic for a link.. is there a way to do this in Excel/VBA/User Forms ?
View 3 Replies
View Related
Dec 2, 2008
I've got a couple of graphics that I want to include in one of my spreadsheets, and I just want to anchor them to a cell. Nothing fancy, no macros, no formulas, nothing like that.
View 4 Replies
View Related
Aug 16, 2009
I want excel to compare both curves, like the maximun % of difference between them. I dont have to same points for both of the curves so i cant do it manually.
View 11 Replies
View Related
Sep 12, 2009
I've been trying for some time to reproduce this type of graphic on Excel with no success. The only thing I know is that is a scatter plot, but that trendline and the %error lines are beyond my understanding.
View 10 Replies
View Related
Dec 5, 2006
I have a folder of numbered graphic files (500 odd) and want to insert the correct graphic in a spreadsheet depending on the value of a cell (the value will be the graphic name). Thus everytime the cell value changes, the correct graphic file will appear.
View 9 Replies
View Related
Jan 30, 2014
I am currently building a template for a project that will allow users to upload raw data which is then converted into a report. Part of this report is a cover page that has a graphic or picture on the front. My question to everyone is this...
Is there a way to put a formula either embeded into the picture, or above the picture, or putting the picture in the background so that the formula can do its beautiful magic and collect the information it needs for the cover?
My goal is for this picture to have the data on top of it without a border so the picture is the background image basically.
View 1 Replies
View Related
Jul 15, 2003
What I want to do is reference a cell, if the value is 1 display a graphic image of a GREEN light, if 2 display image of YELLOW light and if 3 then display image of RED light.
I know I can use conditional formatting to set a cell's color based on value, but I want to use a more eye appealing graphic image (.jpg) to be displayed.
Any suggestions as to how this is best accomplished?
View 9 Replies
View Related
Jul 16, 2009
I have a horizontal graphic chart showing Intel and AMD processors speeds. I was wondering if it is possible to tell Excel to apply a color to Intel processors bar and another to AMD ones?
View 9 Replies
View Related
Apr 14, 2008
I found thru this board's search function the solution to my original or saving excel range into a graphic file. {url} ...
View 6 Replies
View Related
Apr 17, 2013
I have a workbook that has worksheeets for every day of the month. The data in the worksheet consists of columns (employee #, name, clock in/out times, and break penalty).
What I am trying to do is create another worksheet that searches all the other worksheets for a "yes" in the "break penalty" column and then create a list of all the employees that received a break penalty for the entire month. I would like this to be able to auto populate throughout the month as data is entered and not have to use a filter every time I want to compile this list.
View 3 Replies
View Related
Feb 20, 2009
I have four columns of data, as follows:
label 1, value 1, label 2, value 2
I need to create a formula in the fith column that for each line will tell excel to:
look for entry in 'label 1' in 'label 2' if there is a match, then subtract value 1 from value 2, display result.
I have tried doing this with SUMIF but am getting nowhere fast....
View 7 Replies
View Related
Dec 5, 2012
I have been researching this for 3 days and I cannot find a solution. I have City, State information in A1. I also have City, State information in B1. I need to put them into City (D1) and State (E1).
View 4 Replies
View Related
Jul 10, 2009
I have a worksheet with 20+ columns. For this macro, I only need to focus on 4 of them. However, none of these columns are ever in a fixed position so the macro would need to find them by name and NOT by column position. Here they are...
1. Vacation Type (will only have a text value of either "Cold" or "Warm")
2. Vacation Started (will always have a date *x/xx/xxxx)
3. Vacation Ended (sometimes it will have a date '*x/xx/xxxx' and sometimes it will NOT have a date and will be truly blank)
4. Number of Days (currently has ALL truly blank cells)
THIS WHOLE MACRO SHOULD NOT BE CASE SENSITIVE ANYWHERE
Here's what I would like the macro to do...
Scenario 1 - for "Cold" values Find "Cold" text values in the "Vacation Type" column
"Cold" values WITH a date in the "Vacation Ended" columnIF there IS a date in the "Vacation Ended" column in the same row, put the number of days difference between the "Vacation Started" column and "Vacation Ended" column in the "Number of Days" column.
The amount of days in the "Number of Days" column will determine whether these cells should be highlighted GREY or RED.
Scenario 1-AIF the number of days difference is 7 days or less, highlight the cells in the "Vacation Ended" column and "Number of Days" column RED.
OR…
Scenario 1-BIF the number of days difference is MORE than 7 days, highlight the cells in the "Vacation Ended" column and "Number of Days" column GREY..................................
View 2 Replies
View Related
Feb 2, 2008
I am trying to write a macro that will take data from column A and use it as a column header in column C, and then take the corresponding data in column B and list it under the column header in column C. When the value in column A changes it will move on to column D and then list the corresponding data from column B underneath it in column D until all of the data in the 2 columns is spread across the worksheet. Example:..............
View 2 Replies
View Related
Feb 24, 2013
I have a large database of research data where the first column contains different categories (labelled as I, II, III, IV, V, and VI). For each row there is a data value in the second column that is numeric. What I need to do is move the data so that the data are displayed in 6 columns with the data values listed each column heading according to the category label. In the example I've shown there are 6 different categories, but the number of categories (and hence the number of columns in the final resulting sheet) will change for different data sets that I'm using. Also note the the number of cases for each different category is different (so that each column will not be even in terms of the number of rows of data under each column heading). I hope I've been able to explain what I'm looking for clearly.
I've attached a sample file showing the sample data input that I have on one sheet, and then the desired re-tablulated outcome on the second. I have done this using the auto-filter function and copy/paste, but this will take far too long for the larger datasets I'm working with.
View 2 Replies
View Related
Dec 18, 2013
Column A is numbered 1 -100 successively Column B thru D contains data that goes with the assigned number in column A. I need to be able to move rows of data in column B through D to a different set of rows all at the same time (not one cell at a time) without disturbing the set numbers in column A. And with that, have all the other rows of data automatically adjust accordingly(not to be deleted or replaced).
View 1 Replies
View Related
Jul 2, 2008
I have two columns one is web addresses and the other is email addresses but the rows do not line up. I was hoping that since the second half of the email address matches the web address I could somehow sort them so that the email address column and web address column match up. Here is an example but keep in mind that this list is about 9k long and this is just a sampling so you may not see any in this example that match. Also I may have more than one email address per website.
View 9 Replies
View Related
Jan 31, 2013
I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.
I need to move part columns of data from 6 columns to form 1 large column in column A.
For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !
Also need to delete unnecessary 'page headers' throughout as in rows 2-6
View 2 Replies
View Related
Oct 24, 2012
Using the following code to remove empty rows based on whether a specific range of columns is empty. The code works if the cell has a zero, but not when the cell is blank. An example of the data is attached.
VB:
Public Sub DelRows2()
Dim Cel As Range, searchStr, FirstCell As String
Dim searchRange As Range, DeleteRange As Range
[Code].....
View 1 Replies
View Related
Sep 27, 2011
I am trying to create a line graph that will incorporate multiple columns of data in one series of data. The reason I do not place all of the data in one column is because it could exceed the maximum amount of rows allowed in excel. Also I need the data split up for viewing purposes.
I can easily just graph one column but how do I combine all the columns into one line graph with the data being in separate columns. Basically all the columns will be my Y values and X values are just 1:n.
Example Below:
Column AColumn B Column C159261037114812
Now in the example all of the values are x values.
View 2 Replies
View Related
Mar 8, 2014
I have data in sheet 1 like below
Custid loc city
123 us newyork
124 uk wales
876 in mumbai
Sheet 2
custid newcustomerid
123 756
124 394
Outputsheet:
Custid loc city
756 us newyork
394 uk wales
876 in mumbai
So it will check sheet1 custid with sheet2 custid. If both matches it will replace custid with newcustid.if cust id not exists it will load sheet1 recprds as usual.
View 1 Replies
View Related
