show another column when hovering on a point in a chart
Is it possible to show another column when you hover on a point?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point.
...Can the column index in a cell address be made variable?
To refer to a cell with a variable row number, we can just code it as,
Dim i As Interger
Range("A" & i).Select
To refer to a cell with a variable column index, it seems not that easy
because the column
index must be explicitly specified in a cell address. So, if I want to
go to the j th column on the 2nd row or j columns to the right of cell
AA3, is there a quick and easy way to do it? Thank you in advance.
You may be able to use R1C1 terminology, but you'll need to get someone else
to help from here.
"cyberdude" <honc...Sorting Alphanumeric values in a text field
I'm using Access 2003 for a database for my company. I have a field in a
table that has both text and numbers. They are part numbers, for example
21BC124. I kept the field as text because of the text with in the numbers
and didn't figure that a numeric field would alow the text. In my part
numbers table it sorts correctly (first by number then by letter then by
number again), but in my reports and queries there are a few number that sort
in the wrong place. Like this...
I can't quite f...Not allow entering repeated references in a column
If you don�t mind ... I will send it :) .
As I don�t know your e-mail, I will give mine, which is
Just send your e-mail to my e-mail box and I will send the file.
ritinha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1566
View this thread: http://www.excelforum.com/showthread.php?threadid=27195
...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...How do I get text to copy from one cell to another ?
Type = in the target cell. MouseClick the cell containing text. Pres
BrianB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=27034
...if statement with text
I am trying to create an if statement where the string of text contains
total, if yes then perform calculation base on that row and column. if no
total in text leave blank
FIND returns #VALUE if "Total" is not in A1
Therefore, ISERROR returns False if "Total" is in A1 (i.e., it was found, no
Remove 'Junk' from return address.
"jerry" <email@example.com> wrote in message
news:E249057A-F6E4-45BF-929A-B2BB61C3A700@micro...convert text in excel to uppercase
Is it possible to convert all text in a workbook or on a spreadsheet to all
In VBA Editor
Dim MySht As Worksheet, MyCell As Range
For Each MySht In ThisWorkbook.Sheets
For Each MyCell In MySht.UsedRange.Cells
MyCell = UCase(MyCell)
> Is it possible to convert all text in a workbook or on a spreadsheet to all
"elaine" <firstname.lastname@example.org> s...Column comparing
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
Check your earlier post.
Dave T wrote:
> I am trying to compare 2 columns of numbers so that I can identify and
> delete numbers no longer required. Can anyone help me find a formula for
> this please?
> Many thanks
...Prevent Hidden Column data from being copied/pasted?
A student came up with a question that I haven't been able
to figure out yet in a recent Excel class.
They are hiding a column and protecting the worksheet in
the correct manner. They want to allow some users to
access and enter information in some cells. They do not
want the users to be able to copy and paste the
information from the hidden column. The question is how
can this be prevented?
For example, Column B is hidden. When they copy a range
such as A1:C10 and paste it to another worksheet, they are
getting the "hidden" data in Column B in B1:B10.
Any suggestions wou...Hyper link one column to another
I would like to have my columns hyper link one another.
For example: Click on B2 would take you to N2, and vice-versa. Click
on C2 would take you to O2... and so on through column j linked to V.
Is this possible without having to make the link for each cell?
This is a timesheet template and the columns b though J are the hours
and N through V are the text comments for those hours. When I copy the
template to a
new sheet, there will be no data in any column. I would like to be
able to enter an amount or formula (=end-start) for time spent and then
be able to click on that cell and hyperlin...combining columns all the way down
I am trying to combine two columns of information in excel but th
concatenate function doesnt seem to work for it. It may just be m
ineptitude in excel but I just cant seem to figure this out.
I have 3 colums
Column A__________Column B___________Column C
But I cant seem to be able to make it so that column C has tree.jpg an
dog.gif and house.png
Is concatenate the wrong thing to use here? or am I making my formula
I have a total sheet that gets data from three different shift sheets (all
in the same workbook) for a monthly report. I have named ranges on each
shift sheet for each month's production data (S1M1, S1M2, S1M3, S2M1...)
where S1M1 =A2:AC147, S1M2 = A148:AC329, etc. The old formula
was:=SUMIF('SHIFT 1'!$L$1:$L$147,"BB",'SHIFT 1'!$T$1:$T$147). I'm stumped as
to what the new formula would be - how would I direct Excel to column L of
S1M1 to search for "BB", then add the contents of column T? The range
changes each month, and I tho...Look up column name, match rows (a/cnumber) & summing up....its confusing!
Here is what I'v been trying to do but..!
I'v 2 sets of data (data1 & data2) Column name may be sane/different in
each data set and same applies to acct_no.. I want to prepare a report
that combine product & accounts data show accumulatd result on another
Data 1 - upto Jan 2006
Acct. No Total Prod - A Prod - B Prod-C
1001 51 10 30 11
1002 47 15 20 12
1003 80 20 15 45
1004 64 25 16 23
Total 242 70 81 91
Data 2 - Feb 2006
Acct. No Total Prod - A Prod - B
1002 7 5 2
1004 16 10 6
1009 9 3 6
Total 32 18 14
Acct upto Jan'06 Prod - ...Provide space in text
Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.
A1 = Abelia Edward Goucher2 litre
Abelia Edward Goucher 2 litre
A2 = Acer campestre Nanum180stem 6-8
Acer campestre Nanum 180stem 6-8
Thankyou if can be of help.
If you double clcik in the cell with the data then you can move th
blink line to were you wan...Halfway through my publisher document the text starts scrambling
I am in the middle of a Publisher document that I have to get out ASAP and
the words are scrmbling all of a sudden; for instance instead of the it
Might try an updated printer driver.
What version Publisher are you using? What printer? What version Windows?
Canon has issues with Publisher 98 and Windows 98
How to troubleshoot text printing (inkjet printers) in Publisher 2000
PUB2000: Troubleshooting Text Printing (Laser Printers)
http://support.microsoft.com/default.aspx?scid=kb;en-us;198...I need a formula to sum column b if column a is between two dates
I have an excel spreadsheet with employees time off. I need a formula that
will add column b if column a is betwee two dates. For example: if column a
is between 9/22/04 and 9/21/05 then add column b. I have tried all different
formluas but can't get this to work.
...Need to have more Columns available in advanced view
I know how to add columns in advanced view but i can't add all the
columns I'd like to add. I can choose more fields (attributs) as
search attributes than as result columns. Is there somewhere a switch
to turn a field (attribute) into not only beeing searchable but
selectable as a column in advanced search?
Example: "Invoice Product": Is there a way to make an advanced search
or view which delivers field (attributes) of "Invoice Product" as a
...Find a text
I am trying to find a text and delate a Row if the text is in the row.
But I am not sure how to do it.
Can someone help me?
Dim Cell As Range
For Each Cell In ActiveSheet.UsedRange
If Cell = "Samtals hreyfing:" Then
‚the text Samtals hreyfing sin in in the column E:E
‚If the text Samtals hreyfing: is in the row then I want to delete the Row
I think you may be looking for this...
Dim Cell As Range
For Each Cell In Intersect(ActiveSheet.UsedRange, Columns("E"))
...Help with formula: finding text
I would like to ask for help with a formula for comparing name in a cell
with a list of names in a table. If there is a match it should return a
associated text to the matched name from the table. If no match it should
just leave the cell blank. Thanks in advance
Please click "yes" if this post helped you!
"Jonas Ornborg" wrote:
> I would like to ask for help with a formula for comparing name in a cell
> with a list of names in a table. If there is a match...setting a column value in code for an updatable ViewGrid
Is there a way to set the value for a column in code when a ViewGrid row is
edited? I have a row-last-updated date that is a required audit field in
all our systems (required by data management). I don't really want the user
updating this field as it should always be system controlled. If I create
an editable ViewGrid tied to either an SqlDataSource or an ObjectDataSource,
the field seems to only be updatable by the user. I can set it the first
time by setting the DefaultValue in code but that has no effect after there
is an initial value in the column.
Do I need to co...GENERATE a TEXT FILE Using INPUT from a Form ??
I need to generate a Text file using (partly) information entered by the user
on a form.
I already have the TEMPLATE for the text file......I need to generate a COPY
of the file with the word entered by the user into the form INSERTED into the
The text file is actually code for a web page (will have an .htm extension).
The file is simply an exact copy of an existing template with only ONE ITEM
of the text changed to a word that is entered into a form by a user.
One line within the template file is:
"We have several of these items available in BLUE."
I have...Export (or save as) .csv with text delimiters
Has anyone found a way of coercing Excel 2000 to export .csv files with
delimiter text? e.g: as "Mickey Mouse","Minnie Mouse","Donald Duck"
not Mickey Mouse,Minnie Mouse,Donald Duck
CarolineP's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20007
View this thread: http://www.excelforum.com/showthread.php?threadid=345941