Line-Column Charts #2
I am trying to chart 1 column and 2 line data series in one chart with two
different axis. I figured out how to define which axis the data series
references but I have forgotten how to define which data is to be displayed
in a column or line format.
can you riht click the axis concerned and click format and font
and chang the color of the axis figures to that of the color of the chart.
is this what you want.
remove $$$ from email addresss to send email
Mark G <MarkG@discussions.microsoft.com> wrote in message
news:F89C608D-FEAE-44DF-9A15-528CE0EE2247@microsoft.com....Posting cell content on desktop
Is it possible to get the contents of a cell and have it posted (visible) to
your desktop? I don't need the whole sheet, just the contents of a single
Not quite sure what you mean by posted (Visible) to you desktop?
The following code, pasted into the workbook with the data in, when run will
post the contents of cell A1 on sheet1 to a text file on the desktop called
'text'. (Obviously you will have to change the path)
Open "C:\Documents and Settings\Nick Hodge\Desktop\text.txt" For Output As
Print #1, ThisWorkbook.Worksheets("Sheet1&...SUM rows in column if cell in different column is empty
I have a spreadsheet that has many rows of data. I'm trying to get a
total for a column ("G") in a cell ("A2") but only on rows where the
cell in another column ("J") for that row is empty.I tried SUMIF and
couldn't get it to work. Can this be done with some kind of formula?
Any help would be appreciated.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
<email@example.com> wrote in message
news:firstname.lastname@example.org...error C2719 with VC7.1
VC6 compiles fine, but 7.1 flags an error.
C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\vector(507):
error C2719: '_Val': formal parameter with __declspec(align('16')) won't be
This appears to be related to my usage of std::vector in my classes.
Also, I have this at the top of one of my classes's header
#define MYD3DXMATRIX D3DXMATRIXA16
My usage of D3DXMATRIXA16 is not related to std::vector
I never declare a vector<D3DXMATRIXA16> my_matrices;
or anything like that.
For those who don't know, D3DXMATRIXA16 is mean...Moving CRM 1.x databases to new server
Can anyone point me to some good information on how to move CRM databases
from one SQL 2000 server to another? I've been asked to do a feasibility
Afraid with 1.x it is not that easy. First, refer to the Implementation
Guide and look at the Disaster Recovery section. It has the basic steps for
"recovering" SQL to a new server. This is the same basic approach you need
Make sure everything is working before droping the old DB's though as you
may need to go back. Also, make sure you have good backups f everything
(including yo...Excel 2007: Sort by Cell Color
I have Excel 2007 with a fairly new computer and 2gb of RAM. When I try to
sort a spreadsheet by cell color, the program locks up and I have to quit.
There are 46000 records in the sheet - I understand this is a big ask for the
computer but with 2gb of RAM it should be able to do it.
Does anyone have any suggestions as to how I can make this work better?
I hadn't tried sorting by color (cell fill color) before (new XL2007
feature) so I created a 46000 row by 3 column 'database' with two fill
colors in the first column. It sorted in less than 5 seconds on a les...Split tasks a splitting headache
Inherited another Project IMS. I am noticing right off that the previous
scheduler has been starting tasks without their FS preds completing.
Yeah, it does show up as a spit bar in the gantt chart. But, does anyone
know a way to filter out just task that started before predecessor
completion? I'm dealing with several thousand lines. Thanks.
trailerpup's Profile: http://forums.techarena.in/members/116596.htm
View this thread: http://forums.techarena.in/microsoft-project/1290853.htm
...How to randomly split a whole dataset into two sub-dataset?
At your possible convenience, might anyone please kindly answer my
question? Thank you very much.
How to "RANDOMLY" split the whole data set (n=2000) into two sub
dataset (n=1000; n=1000) in SPSS or Excel?
Thank you very much.
Please take care
zencaroline <email@example.com> writes:
> How to "RANDOMLY" split the whole data set (n=2000) into two sub
> dataset (n=1000; n=1000) in SPSS or Excel?
Create a new variable whose value is randomly distributed. Sort
the data on this variable. Take the first 1000 cases ...RMS 2.0 #2
Does anybody know what will be new with version 2.0? Allot of press about
Vista but nothing about RMS 2.0!
This is a multi-part message in MIME format.
They just released updated brochures to resellers last week and I expect =
them to be public near the end of December for either a mid January =
release or heard Friday, maybe February (because of Vista on Jan 30)
Check Point Sof...Sent time 1 hr off
OS: XP PRO SP1
My system time is correct and set to use Auto Daylight
Savings Time. In Outlook, the rec'd time corresponds to
the actual sent time. (I'm testing sending mail to myself
say what time it is)But the time stamp in the SENT MAIL
folder is always one hour later even tho the Calendar
Options are set correctly and also using Daylight Savings
This happens each time I start the computer. The
temporary fix is to go into Calendar Options, I don't
have to actually change anything, just going there and
duplicating the time settings seem to do it. I ca...Disabling 1-2-5-10 Minute security
I 'd like to know if some knows how to disable the "allow permission" to run
for 1-2-5-10 minutes from outlook. I have an application the sends messages
through outlook but it's becoming an issue.
You may find this page useful: http://www.slipstick.com/outlook/esecup.htm
Ben M. Schorr, Outlook-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Peretz Stern" <firstname.lastname@example.org> wrote in ...cells
Ok im trying to grab names from one cell to transfer to another cell on a
different sheet but when I do the = and click on the cell that I want the
information to come from it just places a 0 in that cell and no text. I
changed the cell to make sure the properties are in text format but that
didn't work, when I start a completly new worksheet it works!
Ok anyone know what im talking about ;-0
...Why is my text hidden behind other cells?
I changed my text to be 90 degrees. When I type, the text only shows in that
box. I cannot make it appear OVER the other cells. I need to learn how to
'bring it to front'... if that makes sense. HELP!
I don't think you can. The only ways to show all the text would be to either
increase the height to the row or merge some cells together.
"dANA" <dANA@discussions.microsoft.com> wrote in message
>I changed my text to be 90 degrees. When I type, the text only shows in
> box....how do i change hours and minutes into a decimal number? #2
i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
10mins into 2045.10). can anyone help me with a formula which may help in
this? time is given HH:MM but i need it turned to HH.M.
The decimal time for 2045h 10m is obtained by multiplying the time by 24 and
formatting as general or a number but this will give an answer of 2045.167
and not 2045.1 because .1 of and hour is 6 minutes not 10.
> i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
> 10mins into 2045.10). can anyone help me with a formula w...Display Data On Split Form
Not sure how to ask this but here goes.
In AC 2007 I have a split form that I want to display a value
that will show regardless of the row I select in the datasheet.
This is the number of vacation days one will have through-out
the year and of course it changes as vacations days get used up.
Any help will be appreciated,
"JamesJ" <jjy@darwin_roadrunner.com> wrote in message
> Not sure how to ask this but here goes.
> In AC 2007 I have a split form that I want to display a value
> that will show regardl...Excel files #2
...PDF icon in calculated cells
I have a calculated column and a PDF icon has appeared. If I delete the
contents of the cells, the PDF icon remains. How can I delete the PDF icon?
Right click on the icon and select cut from the popup menu.
"Texas Bald Eagle" <Texas Bald Eagle@discussions.microsoft.com> wrote in
> I have a calculated column and a PDF icon has appeared. If I delete the
> contents of the cells, the PDF icon remains. How can I delete the PDF
...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...how to copy cells data in every 7th row?
I have a column of data from A2 to A65000 and I am only interested in
every 7th data point (e.g. A2, A9, A16....). Is there a way to get those
selected points and store them in the next column (B) consecutviely (b1, b2,
b3, b4, ...)?
Dim outrng As Range
Dim i As Long
Set outrng = Range("b1")
For i = 2 To lastrow Step 7
outrng = Cells(i, 1)
Set outrng = outrng.Offset(1, 0)
> I have a column of data from A2 to A65000 and I am only interes...2 excel programs
I have Excel 2003 and lately installed Excel 2007. When clicking on an Excel
file it opens it using Excel 2007.
I need the files to be oppened in Excel 2003 when double clicking the file.
How can this be done.
I'd try reregistering xl2003:
Close excel (all versions)
windows start button|Run
type your path to excel2003:
and hit enter
and hit enter.
The last version installed or registered should be the default program.
Khalil Handal wrote:
> I have ...Unwanted replicated split screen
I know I could re-install excell but before I do, is there anyone here
who can help me disable a setting that I have no idea how it came
about. I can only describe it as 2 identical execl grids on the same
worksheet. Accompanying image will show you.
|Filename: excel_display_duplication.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=3855 |
-----------------------------------...Count Cells in a particular row w/ text
Is there a way I can total up all the cells in a range which have any
text in them what so ever?
=Counta(A1:A100), will count cells that are not blank
if this helps please click yes, thanks
> Is there a way I can total up all the cells in a range which have any
> text in them what so ever?
That counts TEXT only, ignores numbers.
That will count all non-empty cells regardless of data type.
Microsoft Excel MVP
<email@example.com...Can't find my Front End Folder after database split
I just split my database base to allow for ease of use for multiple users.
Ererything, it seemed, went smoothly until i try to find the fron-end folder.
It is nowhere to be found. Should it be label ****_fe.mbd like the back end?
It will be called that, unless you typed something else in the save as
dialog. I thought it ended up in the same folder as the backend after
Easiest way is to go back to the original and split it again, this time take
note of where you save it before you press the button.
"Joe" <Joe@discussi...Pasting fractions from Word; changing into dates
I am trying to paste a row of fractions in a Word table into an Excel
worksheet. The column is formatted as Fraction. But every Paste and Paste
Special I try puts these in and converts them to dates! Is there any way
around having to type these in by hand?
You can make it work if you put a 0 in front of each fraction in your Word
document and then copy and paste that into your fraction formatted cells,
e.g. to copy and paste
you would enter them in Word as
0 1/2 0 3/4
> I am trying to paste a row of fractions in a Word table into...Split data into new sheets
I have a (very) long list, sorted by account code. I would like to write a
macro that splits the list into separate sheets in the workbook, with a
separate sheet for each account code.
Ideally, I would also like to rename each sheet to show which account code
the sheet contains.
I have no idea, though, where to start. Any ideas? Thanks in advance.
How many different accounts are in the list (more or less than 250)???
below some code that I use to split files by account numbers where the
user has to select a cell within the column that contains the account