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

Excel 2013 :: Presenting Data In Different Columns In Single / Pivot Graphic

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

Reorganising / Presenting The Data

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

Pivot Table Presenting Data

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

Presenting Data Alternative View

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

Transfer Graphic Data To Another Sheet

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

Coordinate System - Combine All Data In Single Graphic

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

Presenting The Math Calculation Instead Of Cell References

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

Excel 2007 :: Multiply Series Values On The Fly Before Presenting In Chart?

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

Graphic As Hotspot

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

Anchor A Graphic To A Cell?

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

Comparing To Curves In A Graphic

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

To Reproduce Graphic Type

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

Insert Variable Graphic

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

Input A Formula On Top Of A Picture Or Graphic?

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

Conditional Formatting - Use Graphic / Picture?

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

Change Graphic Chart Color Bar Based On Name?

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

Save Range To Picture/Graphic File

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

Search Columns Of Worksheets / If The Columns Contain Data Then Form A List On Another Worksheet

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

Subtracting 2 Columns Of Data From Each Other When Labels In Separate Columns Match

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

Splitting Address Data From 2 Different Columns Into City And State Columns?

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

Enter And Highlight Data In Columns Based On Other Columns

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

Move Data From 2 Columns Into Multiple Columns At Each Change

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

Moving Data From Two Columns Into Multiple Columns?

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

Move Rows Of Data From Several Columns But Not All Columns?

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

How Do You Sort Columns So That They Match Up With Other Columns With Like Data

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

Excel 2010 :: Move Part Columns Of Data From 6 Columns To Form 1 Large Column In Column A?

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

Remove Empty Rows Based On Range Of Columns If Columns Are All Empty (no Data) Delete

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

Create Line Graph That Will Incorporate Multiple Columns Of Data In One Series Of Data

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

Replacing Sheet1 Data With Sheet2 Data For Specific Columns Using Macro

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







Copyrights 2005-15 www.BigResource.com, All rights reserved