Linking Time-varying charts
Here's my problem.
I've got a set of Excel files with monthly data which is updated every
month. So in January I only have Jan data. In February I have Jan and
Feb data, and so on.
The chart I have for this data always displays a full 18 months data
from October 2003 to March 2005, and as more data is added, the line on
the chart snakes its way from left to right.
These files are submitted to me from various sources. As a central data
collector, I now want to link these Excel files into a single Excel
file which will display all the charts in one place for convenience.
Ho...A script to replace a value with another
i want to replace a field with another within the same Contact record. Is
there any example that you can show me? i'll doing this to over 5,000
records. i'm using Outlook 2002, personal use.
Phone: (852) 9258 6600
...Excel VB-Copy formula down until adjacent cell (left) is blank?
Here is exactly what I am trying to do through VB in Excel:
Weekly data pull fills colums A:G. Row count is always different. I am
modifying the data pull through VB, and I have a VLOOKUP formula in cell H2.
What I want VB to do is copy that formula down column H to the last row (with
data) each week. I guess I want it to be dynamic so that as rows
decrease/increase the formula is only copied down to the final row/record.
I know someone out of this smart group will know how to do this!
Thanks in advance!
in a macro
dim lngLastrow as long
dim rngTarget...Off by one transaction
When we are posting to the General Legder, the control # of transactions are
off exactly one transaction to the actual # of transactions. We don't
understand why this is so because we physically counted the transactions and
the actual # of transactions are correct but the control # transactions are
off by one. We posted anyway because we physically counted them, but for
future use we would like to know why the # of transactions are off by one.
If you have an answer to our dilemma please respond back.
The Control Total is a number you enter,...One column with different widths
I want to make Column A with rows 1-29 one width and rows 30 and above
Excel does not allow varying widths of cells within a column (or heights
within rows). You could used 'Merged' cells to accomodate the wider
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
View this thread: http://www.excelforum.com/showthread.php?threadid=476150
...Cutting and Pasteing from One spreadsheet to another.
Im trying to make up several templates that contain simliar data references.
I want to cut from one template to another a number of cells.
eg I have the following in one spreadsheet.
I simply want to cut this text exactly as it is and paste it into another
However when I do I get the following
='C:\Documents and Settings\All
='C:\Documents and Settings\All
Re...In excel when inputting dates 10/4/04 (10/april/04) data converts.
In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
I think I'd try chaning my windows regional settings.
In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in d...Adding Lines And Boxes, etc. To A Chart ?
Will blame it on my age.
Using Excel 2007 (or, at least trying to) and XP.
When I have a chart page opened up, how do I get it to show the bar on the
bottom (that the real old versions had) that allows one to click on one of
its icons shown to "draw" lines, arrowed lines, boxes, add text with a box,
etc on the chart itself ?
With the chart selected you can use the Insert tab > Illustrations > Shapes.
To add shapes to the chart. Textbox is in the Text group of the Insert tab.
Andy Pope, Microsoft MVP - Excel
http://www.andypo...CRM & Data Matching
We are going to populate our MSCRM with various data sets. Because of this
there will be duplication of customer data. Is there any mechanism within
Microsoft CRM (or easily available elsewhere) to match the data from the
diverse sources against each other and to arrive at a single instance of the
Microsoft CRM V3 only offers merge capabilities which means you have to
locate the duplicates - crm can then merge the records two at a time. ISV's
have produced other solutions
Microsoft CRM MVP
http://codegallery.got...Calcs & Data Validation
Looking for an easy way to complet the following. I imagine their must be a
quick & easy method.
Cell A5 has a drop down list which corresponds to a range on another
worksheet. It has 300+ entries. In cell B5 i will enter a number/qty. What i
would like is that as each of the items in the list has a corresponding cost
(on other worksheet), i would like to know an easy way to calculate the cost
(in C5) based upon the qty entered (B5) & the cost of the item selected.
I have done it before with 'IF' function for a small selection, but figure
there must be an easier...Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of
hours ago under "Chart Type".
It is URGENT--for a presentation for which I am already late!!
Hi Sat - Take a look at what I just posted and see if it helps.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------...Combination chart? Stacked cylinders and scatter
Hi, I want to make a stacked bar chart that also shows another data
point as a single point along the stacked bar. Here is what I have so
Here is what I want to accomplish:
- don't show Sections where Length is zero -- right now the zero
sections show with label and value on the right side of the cylinders
- show another data point (from another cell in my sheet) as a single
point along the stacked bar
- show a final data point as the total of the bar len...Problem with line Chart
I have the following data:
I would like to create a simple line chart connecting the Value points. Note
that the points correspond to random dates (not evenly spaced). How can I
create a line chart that has time on the x-axis, (say shown in months) with a
line connecting the Value points, which are shown at various locations in
time. Soun...No "Chart Option" feature in the Formatting Palette or when double click on Chart
Operating System: Mac OS X 10.6 (Snow Leopard)
I have read a discussion board concerning this issue but it was from 2008 and no solution was offered yet. The problem is as follows: one creates a graph but cannot add a title or format the axis etc. <br><br>When I open a new spreadsheet and enter the data, I can create the graph. However, I cannot select the "Chart Option" to change any specific features. On the formatting palette I only get the "Page Setup" options but nothing relating to the chart and when I double click on the graph t...How do you convert or copy your dbx files to pst files
...Formatting doesn't follow data sort
I was just recently updated to 2003 MS Office Pro. I can't remember
what I use to have, but I used to be able to Data Sort info and the
borders around cells would follow the appropriate text. It doesn't do
that anymore, and I can't find out how to fix it in the online help,
and my IT guy doesn't know off the top of his head. Can anyone help or
have I wasted a full day and a half putting borders around information
for no reason?
kanimalhouse's Profile: http://www.excelforum.com/me...Duplicate emails received (two copies)
I am receiving two copies of each received email. What
could cause this problem?
...How do I copy previously entered data
If I enter related data in A1 and C1 and then type the same data as A1 in A4,
how do I get the data in C1 to automaticallyh appear in C4?
> If I enter related data in A1 and C1 and then type the same data as
> A1 in A4, how do I get the data in C1 to automaticallyh appear in C4?
Thanks for the information, I tried it and it works.
One further question if I may?
If I type the info in A1 in multiple places in columnA, can excel be
repeat the related info in c1 in the cor...Data validation causing problems when using a data form in Excel 2
I have an Excel 2007 workbook that includes data validation set on a number
of cells. When using a data form to enter data and I enter an invalid value
on the form field corresponding to one of those cells I receive the
validation error dialogue that prompts me to retry. I enter the correct data
into that field on the form then close the form. My worksheet only has the
data relating to the corrected field entered. All other data entered via the
form is not entered onto the worksheet.
Is this a bug in Excel 2007? I previously was using Excel 2002 and found
that when using a ...How to credit complicated pie chart
I want to create a pie chart of my credit card statement each month.
Every pie chart example shows 3 columns and about 5 rows of data. I
can create a chart for something that simple but what I need is
A chart showing the amounts and to what merchant that amount was spent
Can someone point me in the direction where I can find something that
would tell me how to do what I want?
...Data Validation, Via A Formula
Is there a way to apply data validation to one cell, based on the result of
another cell? For instance, if in A1, a data validation list displays sports
(ie baseball, basketball,etc), and if the user selects "Baseball", then the
data validation in B1 would only list baseball teams, from the range named
baseball teams. And if basketball is selected, then only basketball teams are
If at all possible, could this be done via a formula and WITHOUT using VB?
If not, I could also use any help to accomplish this via VB coding.
Any and all help will be appreciated...Multiple series not plotting in their respective data ranges
I have a price comparison chart (line chart) that has multiple prices for
Price 1 has a date range of 01/01/07 - 02/06/07.
Price 2 has a date range of 01/19/07 - 01/31/07 (a subset of the Price 1
range). When Price 2 plots, it starts at the left of the overall range
(01/01/07) and stops at 01/13/07 instead of plotting in the middle of the
chart starting at 01/19/07 and ending at 01/31/07.
Is this a bug or is there a parameter setting I need to tweak?
If you want to plot one variable (price) as a function of another variable
(date), you should be using...Project data and time imported into Excel
I am exporting date fields from Microsoft Project into Excel, the problem I
am having is finding a way of getting rid of the time portion as it is
interferring with the calculation.
I understand that a date and time is stored as a double, the integer part is
the date and the decimal part is the time. I would like to easily remove
the decimal part of the imported part.
Any help would be good.
You might want to split the time and date into two separate columns.
If your date/time is in A1, you can split them like this:
Format the cell...Hyperlink from one sheet to the hyperlink on another
I want to click on a hyperlink on sheet1 and have it open a hyperlink on
sheet2, rather than just going to the cell reference on sheet2.
I can't work out how to do it. Does anyone have any ideas?
> I want to click on a hyperlink on sheet1 and have it open a hyperlink on
> sheet2, rather than just going to the cell reference on sheet2.
> I can't work out how to do it. Does anyone have any ideas?
Why not include an optional second hyperlink on sheet 1 which goes straight
to the point that the hyperlink on sheet 2 is directed?
The idea is that all of the...Two different organizers in one meting
imagine the folowing:
Person A is the assistant of Person B, who has given delegation on his
When person A makes a meeting request in the calendar of person B and has
made a reservation of a resource (meeting room), everything seems to be
working fine. however, when person A opens the meeting request in the
calendar folder of Person B, I can see that the organizer of the meeting is
Person B. When I open the meeting in the calendar of the resource mailbox,
the organizer of the meeting is Person A ??
This occurs with Outlook 2007 SP2 and Exchange 2010.
Is there a way t...