Auto Scale X axis doesn't work with "" values in cell
First of all, thanks to tushar:
I'm trying to get a chart to work with the basic ranges defined as this:
XValues =OFFSET('Basic Range'!YValues,0,-1)
YValues =OFFSET('Basic Range'!$B$5,0,0,COUNTA('Basic Range'!$B:$B)-1,1)
Assuming dates in A5-A16 and data in B5-B16.
However, this won't work if the data in column B is equal to this ""
I get the "" from an if statement: If cell in column A is blank, then cell
in column B = "" or =IF(isblank(A11),"&qu...linkingof charts in worksheets to cells
I have copied some charts into the worksheets which I want to link to cells
in the first sheet.I have too many charts to copy and paste into the
worksheets.Is it possible to copy numerous charts into seperate worksheets
(about 100 charts) as the charts are very large in size and link them to each
cell in the first sheet.
thanking you for you help
...Empty the Inbox
Is there a better way to empty all messages in the Inbox than holding down
the Cntrl key? Just used the laptop after several months, and it downloaded
all the old emails on the server. Using Windows Outlook Express.
This is not the Outlook Express newsgroup, but anyway: If you want to
delete all the Inbox messages, highlight one header viewing in the Preview
Pane, and Ctrl + A will highlight them all. Delete all in one motion.
Imperial Beach, CA
"k. bob" <firstname.lastname@example.org> wrot...Selected cell will not release
Occasionally after I have selected a cell in MS Excel 97
it will not release by left or right clicking and when I
move the mouse the other cells are slected. These also
will not release. The only way out of this situation I
have found is to terminate the program using Ctrl-Alt-Del.
This is very annoying. Is this a know problem and if so
what is the solution?
I have Pentium II with Windows 98 and 256 MB of RAM.
Next time this happens, try pressing the F8 key.
For more information, take a look here:
"John Greenhill&qu...have cell display the word balance when a equals the same amount a
I want a cell to display the word balance
example cell "A" is the same amount in cell "B" cell "C" will say BALANCE
is this possible?
Custom format C2, the formula cell (of ) as:
> I want a cell to display the word balance
> example cell "A" is the same amount in cell "B" cell "C" will say BALANCE
> is this possible?
Put into cell ...Looping until empty column
Here is my dilemma. I can do VBA in Access, but for some reason I jus
don't get it in excel. What I want to do is go down a column and stor
that info in a variable. I want this to happen untill there is no mor
data. Once I have that data I want to go to another page and store th
data in an empty column. I want the program to auto. find the empt
column. Thank You in advance.
theguz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2491
View this thread: http://www.excelforum....Can you have both average and standard deviation in the same cell?
Or, if I want to make a chart which will show both the
average and stardard deviation of mutiple samples in a bar
chart graph(e.g., data like below column A and B), how
should I do that?
Thanks for the help!
A B Average STDEV
1.0 1.0 1.0 0.0
0.5 0.7 0.6 0.1
0.6 0.5 0.5 0.0
0.5 0.9 0.7 0.2
1.5 1.0 1.3 0.2
2.4 1.0 1.7 0.7
0.6 2.9 1.7 1.2
2.0 1.4 1.7 0.3
1.2 1.8 1.5 0.3
0.9 2.0 1.4 0.6
1.6 3.0 2.3 0.7
5.8 3.4 4.6 1.2
[This followup was posted to microsoft.public.excel.charting with an
email copy to Andy Zhao.
Please use the newsgroup for further discussion.]
First, the standard dev...Cell as Button
I can add a button to my sheet, but it seems to float over the cells.
Can I add a button so that it is in a cell? Or, alternatively, change
a cell so that it looks and behaves like a button?
Presumably, you want clicking the cell to activate some macro code. You can
use the Selection_Change event to make any cell act as a button. This goes
in a sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("MyRange"), Target) Is Nothing Then
''' put your code here, or a call to it.
The best yo...Formula to change text format to BLOCK CAPITALS
I have created a spreadsheet to record names of guests invited to an
event, with a yes/no drop down list [column B] to record their response
to the invitation.
I want to create a formula which will convert their name [columns D &
E] to BLOCK CAPITALS if I record a 'yes' response. I don't know how to
make this happen, beyond knowing I have to write some kind of formula.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
"Georgeina&quo...pst file appears empty
I have a 450 MB pst file, that appears empty in OL98.
I have run scanpst several times, did not help.
I changed the first byte of the file from 21 to 00 with a hex editor and ran
scanpst, it did report errors, fixed them and still no help.
I tried exmerge, which reported succesful import, but did not actually
retrieve anything from the pst file.
Mdbvu32 also shows that the stuff is in there.
It seems that the problem is quite common, but does anyone have
a solution, how to fix it.
...logging date & time of data entry for individual cell
I'd like to log the time & date that content was entered into a (formerly
When any data is manually entered into cell A1, the then-current time & date
goes into cell B1 (and henceforth doesn't change). When data is entered into
A2, the then-current time & date goes into cell B2. Once data has been
entered into a cell, it will not be edited again.
Can anyone suggest the best way of doing this?
Put the following macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A:A")
If Intersec...excluding cells from calculations by "marking" the cells?
Within a range of cells designated for a calculation, I am tyring t
exclude certain cells without having to modify my function (usuall
very complicated) or using conditional formatting.
- 10 data values, function calculates result
- 2 of the data values (never the same two) are unacceptable
I want these two values to be excluded from the caculation. What I nee
is a way of designating these cells as "Ignore". I don't want to delet
the values, nor do I want to cut out the cells.
Any ideas? Thanks
Message posted from http://www.ExcelForum.com
Are these '...Excel default number format problem
I have a user with an incorrect default cell format in Excel. His
default number of decimal places for a cell with numbers is set to 4
instead of 2. I have no idea how he caused this and I have no idea how
to correct it. In case I'm being ambiguous, here is the procedure:
Open a new Excel workbook, choose any cell and go to Format. In the
Format Cell dialog box go to the Number tab and choose the Number
category. The Decimal Places box will be set to 2 by default but in
this user's Excel it is set to 4. How do I get it back to the default
http://www.imagedump.com/index.cgi?pick...Empty Cell not empty
If I use the following formula:
=IF(B25="","",B25+C25) in Column U all the way down
to Row 20000
to create a new value...
(Column B has a date and Column C has a Time) and then
copy and paste Column U to Column T as values, I see empty
cells in Column T once my data runs out (presently around
However....if I use the CountA function,it is telling me
that I have data in Column T all the way down to Row 20000.
Since this combined Date/Time is being used as X Axis data
it is screwing up the graph because Excel thinks those
cells are Jan 1, 1900 when in fact...Conditional Formatting?
I am not an experienced Access 2007 user so this may be an easy one.
On my reports I want certain lines to be bold depending on certain criteria.
The criteria is basically: If Date A is before Date B AND the difference
between Date B and Date A is less than 3 years then I want that record in
Can this be done? The dates are in my query that my report references. Do
the dates have to be part of the report. I have used advanced filtering on
fields not in the report and it works so I hope I don't have to include them.
Message posted via http://www.accessmo...How to remove or replace a carriage return character in a cell?
After importing a Cognos "hotfile" into excel, the cell contains a carriage
return character (looks like a square) and I want this to be a new line feed.
I have tried to determine how to do a find and replace, but no luck. Help!
Saved from a previous post:
You can use Chip Pearson's Cell View addin to find out the character it is:
If those box characters are char(10)'s (alt-enters), you can use
If that box character is something else, you may need a macro:
Option Ex...interpolating blank cells
I want to graph the data from a table, but I want the charts to interpolate
the lines inbetween the "blank" cells. All of the cells have formulas in
them because they are pulling the data from another worksheet, but some of
them appear blank because there is no data for that time slot. I have tried
the Tools:Options:Charts: Interpolate blank cells, but I can't get it to
work. Please help. Thanks.
You see a cell with a formula is not blank
Replace you formula by =IF(your-formula="",NA(), your_formula)
Such as =IF(Sheet1A1="",NA(),Sheet!A1)
...Empty Excel file is too large
I have deleted all sheets, and contents from my excel
file, but it's still 2Meg in size. When I zip it, it's
only 90K Bytes. (A blank excel file is usually 90K Bytes)
Why is my empty file so large?
It was originally 5 Meg, and I deleted all sheets,
formulas, and VB codes. Right now there is nothing (except
one empty sheet), but the size is still 2M.
Sometimes what I find is that Excel counts unused rows as
part of the file size.
So what I do is highlight all the rows from the first
unused one to the last one, i.e. ctrl+g to bring up the
goto box, then Ax:a65536,...Cell relation ships.
What are cell relationships and how do i use them.
not a specific enough question, could be interpreted in many ways ... if
this is a homework question, was there any more to the question than this?
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Slukes" <Slukes@discussions.microsoft.com> wrote in message
> What are cell relationships and how do i use them.
This is for my GNVQ ICT coursework.
We are creating spreadsheets for a customer of our choice. ...Contacts dialogue box shows up empty
I have an issue with Outlook Pro installed on my main PC that is not
recognizing contacts. They are all there, but when I try to send an email,
and I select "to" the contacts dialogue box shows up empty.
Thanks in advance,
Is the Contacts folder selected as an Address List?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-FREE tool; QuickMail. Create new Outlook items anywhere from within Windows
-Properly back-up and restore your Outlook data
"Jay" <nospam_doctorpep...ignoring empty???
one of my students presented me with the following:
"I get a list from another application.
There is a column that has either value "yes" or looks like empty.
Now, when I want to jump to the next row that has value "yes" I use the
shortcut key Ctrl+ArrowDown.
However, sometimes when a cell looks like empty there may be a space,
with the result that when I need to jump to the next "yes" cell I end up
in a cell that has a space. (one that looks empty)
So, I used the function Trim to get rid of all the superfluous spaces in
an extra column. And al...Conditional page breaks?
Is it possible to setup up a macro for conditional page breaking? Let's
say I have an employee listing sorted by department name. When the
Department name changes I would like a page break. Could this be possible?
The list is too large to manually insert the page breaks. Thank you ahead of
Maybe you could use Data|Subtotals.
You get an option to add page breaks.
And when you add more info, just remove the data|subtotals, sort your range and
> Is it possible to setup up a macro for conditional page breaking? Let's
> say I ha...Choosing cells based on date...
Hi! I have a cell that is supposed to add up two types of figures:
- two other numbers from different spreadsheets (I've figured that out!)
a series of cells on this sheet, "up to the current date".
It's this last number I have no idea how to get.
We're not using date fields or anything either, just a simple column system
day of the week date amount which we modify month to month.
Is there a way of doing this?
Hopefully I'm relatively clear... Let me know if something doesn't make
sense. Wouldn't surprise me... it *is* Monday after all!...How to put cells in a document to organize it?
I scanned 2 columns of words with 25 rows..I need be able to show the lines
when I print it..I will be using it as a study sheet ..to write definitions
to the words..when I scan the sheets..there are lines when I print it there
are no lines..
Can someone help me ..I would appreciate it...
I'm assuming the scan is now a picture. Have you tried using the
contrast/brightness tools on the Picture toolbar?
Or create a table over the scan and adjust it to fit.
"yoko" <email@example.com> wrote in message
news:AA3DDAEF-...Capture data from cell before Enter
Is there a way to capture what the user types into a cell before they hit
enter? I would then feed this data into a lookup to prompt the user with the
correct cell input without having to type the whole thing everytime.
while typing into a cell, you are in edit mode and that sort of locks things
up until you do hit enter. so i don't think this would be a viable solution.
i would recomend that you read up of data validation. this is what data
validation is for. insuring correct input. and with data validations you
might be able to select the correct input from a VD drop do...