# Display Th % Difference Of The 2 Months Either In The Chart Or In A Table

Mar 16, 2009

I am using a stacked Data chart with Layout #5. See attached. I calculated in a table below the % difference between the 2 months, but is there a way to display this % difference of the 2 months either in the chart or in a table (or both)?
Is there a way to modify the table only? Or is there a different type of chart that can display this?

## Using Pivot Table / Chart Or Other To Display Top 10 Companies By Quotes / Sales

Aug 13, 2014

I have table with companies across in columns, months down the side in rows, and 6 parts to the data in addition to company and month. I have quotes from 3 different sources, and won deals from those 3 different sources. How do I create a pivot table/chart to analyze the data quickly, or find out Top 10 companies quoting with value and top 10 companies with won deals?

I have attached an example, taking out the company names with A, B, C, and source with A, B, C. The cells do have an array formula which picks data from another spreadsheet. Which, by the way, is really slowing my machine down each time I type something into the spreadsheet.

Quotes.xlsx‎

## Difference In Months Between 2 Dates

Sep 27, 2007

say C2= 22/02/2007. in cell C4 When I use this formula =TODAY()-C2 to get the difference between today and a past date the result the formula give is 07/05/1900
i would like to receive the difference in Months between the past date and today? I.E. HOW MANY MONTHS IN BETWEEN

## Find The No. Of Months Between The Difference Of 2 Dates?

Feb 21, 2009

what is the formula to convert the date in MMYYYY into some numbers so that I can derive the difference between 2 dates?

For example:
I have 2 dates 31-Jan-09 and 28-Nov-05 in Column A & Column B respectively. I would like to derive no. of months between the difference of the 2 dates which in this case is 38 months.

## Color Cells Based On Difference In Months Of Dates

May 14, 2008

I have dates in Column D (mm/dd/yyyy). I'm trying to write a macro to compare the date in any cell in Column D to the current date. Then, if the date in that cell is within a month of the current date, color it red. If the date is within two months, color it orange. Etc, for up to six months. I've read up a little on dates in VBA, but I'm pretty lost.

## Calculating Difference In Months Between Dates / Ignoring Days And Years?

Mar 13, 2012

Cell A1 contains 02/29/2012

Cell B1 contains 12/01/2006

I am looking for a formula that will return the number of months (periods) between two dates, ignoring days and years. Using the above dates, which cannot be changed, the result needs to be 63. The formulas I have tried keep returning 64 because my later date is at the end of a period, and my earlier date is at the beginning.

## Chart By Months

Feb 17, 2007

I am trying to understand how the Charts by month example has been created. So far I have managed to create the validation and define a named range with the offset formulae. However when I select the month from the validation list it only changes the y axis labels on the graph and not the data itself (example attached). I must be overlooking something very simple. I would also like to know if it is possible to create a further selection where by you could also define a start month e.g. assuming data range of Jan-Dec you could select March - September.

## If Statement: Need To Display The Difference

Mar 23, 2009

If the first 2 columns do not equal 9, the third column needs to display the difference. I tried a normal 'IF' statement, but I'm a little to novice it seems.

## Formula To Display Same Date For All The Months

Jul 31, 2013

I have a excel file which deals with accounting systems. It has the Loan date in Cell B6 and Number of dues in cell B7. I need the column from B11 : B34 to be filled with due dates for every month. Suppose if the loan date is 12/05/2013 and number of dues is 10 then in B11 I should get 12/06/2013 , B12 it should be 12/07/2013 and B13 should be 12/08/2013 and so on based on the number of dues.

## OR Or IF Adding: Display A Date 3 Months In Future?

Nov 19, 2009

Three columns.

A - Date last checked
B - Due Date
C - Actual Date checked

Currently column B simply has =A+84 and will display a date 3 months in future.. Great..

However now i want column B to still display the 3 month date - unless there is a date in C, whereby i want B to then display OK. SO what im sort of needing is =A+84 (or if somethings in C then "OK")

## Display Popup When Percentage Difference Reached

Feb 16, 2008

I have an excel file that linked to an external feed that receives stock prices in real time. on the file i have the stock name, the price paid and the current price. I would like to have a popup that shows up whenever a stock price has a 15% or higher return. I would like the popup to show the stock name. I realise that conditional formatting would highlight whatever is over 15%, but the workbook has multiple worksheets and I would like it to popup even when i am on another worksheet.

Enclosed is a copy of the file (the actual file has many more sheets) : john.zip

## Display Result Based On Time Difference

Feb 15, 2008

I want to make a formula based on 2 times ex: 10:07:00 and 10:09:00. This formula should display "intime" if the diference between both is under 20 minutes, "outime" if the diference is above 20 minutes and it should display "error" if the time is under 0 minutes (this will only happen when someone makes a mistake typing in the time. For example 10:37:00 and 10:36:00)

## Display Popup When Percentage Difference Reached

Feb 16, 2008

I have an excel file that linked to an external feed that receives stock prices in real time. on the file i have the stock name, the price paid and the current price. I would like to have a popup that shows up whenever a stock price has a 15% or higher return. I would like the popup to show the stock name. I realise that conditional formatting would highlight whatever is over 15%, but the workbook has multiple worksheets and I would like it to popup even when i am on another worksheet. enclosed is a copy of the file (the actual file has many more sheets)

## Chart That Automatically Shows Last 12 Months Of Data

Mar 5, 2014

See attached file. I have managed to work out how to update a chart automatically when a new row of data is added. However is it possible to tweak the formulas I am currently using so that it will only include 12 months previous.

For example if you add Jan in to row 26 the chart will show Feb-Jan data (Row 15-26).

Book1.xls‎

## Showing Only Active Months In Chart Data?

Feb 5, 2013

I've attached a chart with variance data for each month of the year. I've used an IF formula to "NA" the months with no data, so nothing shows up in the chart. However, I would like to know if it's possible to have the chart only show months with data. The IF formula gets rid of the data point but it doesn't prevent the chart from showing the month on the X axis. In the attached file I manually selected the three months with data.

## How To Make A Cell Display Text Difference Between Two Cells

Aug 30, 2013

Is there a way to make a cell display the text difference between two cells?

For example of cell E2 reads "Thank Goodness it is Friday" and cell F2 reads "Thank Goodness" can I put a formula in H2 that will show the text that is in E2 but not F2 ( "it is Friday")?

## Chart Twelve Months Of Data For Item The User Has Selected

Oct 24, 2011

how can I provide a chart that display as a line chart twelve months of data for the item selected starting or ending on the data that I have selected

## Pivot Table - Grouping Months

Jan 5, 2012

I'm trying to create a pivot table to figure out categories of expenses over the last year. The problem is when i create this pivot table on the horizontal i see all the days of the year, as opposed to categorized by month. I've tried to 'group' the months together but not very successfully. HOW to do this grouping elegantly?

I've attached 2 screenshots.

Pic 1 - Original State of the table with all the days on the horizontal

Pic 2 - an attempt to group by month, gone wrong

## Table Only 2 Months Long Then Stop?

Dec 26, 2012

the first cell in my table has a date but I only want the table to be 2 months long so normally I would use the formula =cell above+1 but with different length months that wont work so then I thought can i have a formula like

=if(B7>\$B\$7+2months,"",B7+1)

where b7 is the first date of the first month

## Pivot Table Filter - Combine Months

Jul 14, 2014

I use a spreadsheet to extract data from an access database. When the data is extracted it has about 10k line items and one of the columns displays the date. I formatted the cell to simply display the month (Jan, Feb, Mar, etc). When I create a PivotTable with the 10K line items each line displays the month. When I use the date as a filter it displays every single lines month in the filter box. Is there any way I can combine the months in the filter box so that each month would only display once collectively instead of for each line item?

PT.jpg

## Delete Fields That Correspond To Certain Months In Amortization Table

May 23, 2013

I have a sheet (like example attached). it's broken out by month for many decades. certain columns like B-N need each field populated. There are others like O, P, Q, where I need to delete all cells except for 2 months that year (in this example, all except May and November).

Is there a shortcut method to do this quicker?

example.xlsx

## Months Displayed In Proper Order In A Pivot Table

Oct 1, 2008

I need to build a macro that creates a pivot table that displays data for the last 13 months, by month (e.g. Sep 07 - Sep 08). My table has a column for months and another one for years. My question is: to run the macro succesfully, how should I build my table, or make the pivot table, in order to get the months displayed in proper order (Aug 07, Sep 07, Oct 07, Nov 07, Dec 07, Jan 08, Feb 08,.......Jul 08, Aug 08)

## Calculate The Difference Between 2 Columns In Pivot Table?

Aug 14, 2014

So I am running in to a large brick wall! I have a single pivot tablet with a column for items received and then a column for items shipped. I would like to create a calculated field in the pivot table that will subtract the items received from the items shipped columns. I have attempted to add the calculated field using the tool bar but it keeps giving me "0" for every item on the pivot table when there are obvious differences.

## Calculate Difference Between 2 Rows In Data Table?

Aug 7, 2013

I have a data table with incidents in which one column is equipment number and one is data of occurrence. I now need to calculate how long ago the same equipment number occurred.

## Calculate The Difference Between Two Columns In A Pivot Table

Aug 26, 2009

Is a way to calculate the difference between two columns in a Pivot table .

I have the data something like this in a pivot table....

Sum of MetricValueColumn LabelsRow LabelsFebruaryMarchAprilMayJuneJulyNet New My SitesNet New Team Sites0Number of Provisioned Users322059319906322372350239332914328404Total Capacity In Use (GB)1585.381722.761824.731947.772124.282262.78Total No. of My Sites208212316924682307313313134317Total No. of Team Sites101751082311396683273227940

What i need to do is to calculate the "Net New My Sites" and "Net New Team Sites" values something like this....
Net New My Sites (March) = Total No. of My Sites(March) - Total No. of My Sites(February)
Net New My Sites (April) = Total No. of My Sites(April) - Total No. of My Sites(March)

## Pivot Table - Calculate Difference Between Two Calculated Fields

Mar 29, 2012

I have a pivot table listing different company names in the first column under 'row labels' and there are calculated fields, a count and an average in columns B and C respectively. Is it possible to insert another field in column D that calculates the difference between values in column B and C (even though they are calculated fields themselves)?

## Excel 2010 :: Pivot Table For Financial Statement With Months As Columns

Jul 4, 2012

Excel 2010. I set up a trial balance as following:

1/31/2000 2/28/2000 3/31/2000 ------- 12/31/2012
Acct # 1
Acct # 2
Acct # 3
Acct # 4

I was able to use pivot table to set up the balance sheet and income statement.

1. now each month is a field which I can choose to add to the report, but the field list is getting too long (and growing). Is there a way I can insert 1 field (for the user to input the exact date) or 2 fields (to input year and month) and the pivot table can pick up the input and refresh either automatically or manually.

2. I looked into the "group" function in pivot table, but how do I group the above data in quarterly and yearly fashion so the user can get those information quickly?

## How To Compare Percentage Difference Between Date Range Through Pivot Table

May 9, 2014

I would like to compare % difference between date range through pivot table

Date RangeProductAmt
1st weekABC1000
2nd WeekABC2000
3rd WeekABC1259
1st weekXYZ3000
2nd WeekXYZ4000
3rd WeekXYZ2500

How to plot a Pivot table to compare the % difference between 3rd Week Vs 2nd Week Vs 1 Week for each product through pivot table?

## Create Pivot Table That Has Calculated Field For The Difference In Amount

Feb 27, 2013

I have 3 fields:

Person, FinancialYear, AmountUSD
Pete, FY12, 8000
Pete, FY13, 7000
Jeff, FY12, 5000
Jeff, FY13, 5500
Sam, FY12, 4000
Sam, FY13, 3500

How to create a pivot table that has a calculated field for the difference in AmountUSD between FY12 and FY13 (for each person).

## Display Average On Chart?

Sep 17, 2012

On this chart the X-axis are dates and the y-axis are daily scores. The chart shows each day's data point and computes a trend line. How can I dynamically calculate and display the average score as a single value somewhere on the chart? I could calculate the average in a cell outside the chart object but would like it to be part of the chart. I do not want to show the average as a separate horizontal line within the chart grid.