Line Chart #13
The following is my data and I need to chart this. Is it possible to have a
range in one cell?
Thanks for your help in advance
Experience (Years) Large Medium Small
1 $90,000-$100,000 $75,000-90,000 $65,000-78,000
2 $92,000-100,000 $80,000-95,000 $75,000-85,000
3 $105,000-130,000 $90,000-100,000 $85,000-95,000
4 $117,000-150,000 $100,000-115,000 $90,000-110,000
5 $140,000-170,000 $115,000-130,000 $100,000+
6 $140,000-190,000 $135,000+ $100,000+
7 $170,000-250,000 $135,000+ $110,000+
...Fixed Assets across business lines
Hello everybody -
Is it possible to spread fixed asset depreciation across multiple business
lines? We have certain assets that need to be depreciated across multiple GL
accounts..is this possible?
The simplest solution would be to use an allocation account (probably
a fixed allocation account) as the depreciation expense account. This
would spread the depreciation based on the percentages in the
allocation account to multiple accounts.
On Sep 27, 4:25=A0pm, modon...@knight.com
> Hello everybody -
> Is it possible ...profile not recognized
When I open outlook it tells me I have no profile, even
thou I did create one at control email. I can send and
recieve email with outlook express no problem, but I cant
access outlook to view my PDA sync info. Please help!
...Microsoft Outlook -- Pass Line Variable to Microsoft Access
Okay...I tried the Microsoft Access main newsgroup and didn't get an answer
to my question; hence, I'm asking the Outlook professionals. Here's my
Whenever a new e-mail message is received with a pre-defined subject line, I
want a VBA script to pass line String variables (from the body of a new
message) to a Microsoft Access function (module).
If I can pass the line variables from Outlook to an Access function, I would
be all set. However, I am not sure how to capture line variables of a new
message in Outlook, and how to pass them to Access.
Any help would be...How to get Recurring Appointment dates with VBA?
I need to loop through all future Outlook appointment items and populate a
table with the date and subject of each appointment. The problem is with
recurring apointments - how do I get the recurring dates? If the
appointment is NOT recurring, this works:
Dim ola As Outlook.AppointmentItem
For Each ola In olns.GetDefaultFolder(olFolderCalendar).Items
If ola.Start > Date Then
myDate = ola.Start
mySubject = ola.Subject
But the above code will not return recurring appointments.
I've tried this, but no luck:
If ola.IsRecurring Then
Dim varItem A...VBA Code to Run External File Commands....
I have a small VB Code that trying to do 2 different things, but both
need to go outside of Excel.
( copy / paste )
'Open "C:\myfile.PAS \\BLOCKP_5\WDDrop" For Output As #1
'Copy "C:\myfile.PAS \\BLOCKP_5\WDDrop"
I run a macro that takes the contents and creates a .PAS File, (
midified CSV ), that file is then copied to a Label Program ( Loftware
) and it prints out labels.
Currently, I added a command button to click on it to run the macro,
it copies file to the C:\ drive, then I mi...Excel 2003 - VBA
I have a spreadsheet where I am pulling Account data from several sources.
One thing that I am looking for is to see if a given account has been on the
same strategy for the duration of the period under test.
Visually I would determine this by scanning a row of data to see that the
strategy code (Alpha Code) was consistent throughout the period.
Is there a quick way of looking at a range of cells and determining if they
are all the same? The period could be several hundred cells long.
You can use a formula like:
=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A...Filter a report by start and end date
* I am VERY new to MS Access, please forgive me if I do not give the
I have a table with a date column along with other columns with my
necessary information. I have created a Report that displays my
information by month. My problem is that is displays every month that
is in the table. How do I make the report allow me to just look at 1
month at a time.
I think what I need to do is set up some kind of form with a filter
that will let me enter a start and end date that will somehow link
back to my date column in my table and then filter my report for me.
I am complete...Input from Access
I have an excel spreadsheet linked to Access.
I input some information in Access and it appears in the Excel ss.
The problem is that the numbers are formatted as text. This produces an
error because the numbers are in a summed column. In Excel the column is
formatted as number.
Any ideas on how I can force the text to be formatted as number when it
receives new data. The Excel Form is not open when updated by Access.
Any help greatly appreciated,
How are you transferring the data?
> Hi All,
> I have an excel spreadsheet linked to Access.
&g...Format all contacts with specific telephone input for Outlook and Motorola A1000
Some of my contacts from Outlook 2002 have entries like this:
+44 (20) 12345678
and some have:
How can I make *all* my contacts on my A1000 have the telephone numbers
in this format:
where *cc* is country code
*ac* is area code
and *nnnnnnn* is the telephone number.
I would like them in that format with the "+" at the front (int'l
format) and "-" seperating the numbers.
I *don't* won't any spaces or parentheses in the numbers. It seems when
I sync with the phone and Outlook, I get different entries - some with..."This workbook has lost its VBA Project"
Receiving the above message when opening Excel2003, blank workbook.
Tools -> MACRO everything disabled except for security which is set to medium...
I have installed EVERYTHING run from computer, including common VB support.
And you get this when you click on the New icon on the standard toolbar?
If yes, do you have a workbook named book.xlt in your XLStart folder?
That's a template file that excel will use when you create a new workbook. If
that template file had macros, maybe it got corrupted and excel is having
trouble with it.
In fact, if you have a book.xlt in y...how to add overlay line chart to stacked bar
I'm using Microsoft Excel for Mac OS X. I'm trying to create an overlay
chart with a stacked bar with a line over it. I can only get it to do a
regular bar chart with a line over it. What am I doing wrong? Thanks!
I no longer have a Mac, but you can try the following:
1. Create a stacked column chart from all the data
2. Select the series that you want as a line
3. Choose Chart>Chart Type, and choose the Line
chart type, and one of the subtypes
4. Click OK
Molly M wrote:
> I'm using Microsoft Excel for Mac OS X. I'm trying to create an overlay
> chart with ...How to stop the End User License Agreement popping up?
"log in as system administrator" means what?
I turn the thing on, I don't have to log in. I'm the owner!
In simple terms now, why do the End User License Agreements pop up every
time the program is opened? this occurs for Picture Manager and Outlook and
How do I permanently stop this happening?
Probably better ask in the appropriate Windows newsgroup.
"blackheath" <email@example.com> wrote in message
> "log in as system administrator" means what?
> I turn ...tangent line #2
how can i draw a tangent line on a graph with a curve of best fit?
On Tue, 18 Sep 2007, in microsoft.public.excel.charting,
mark <firstname.lastname@example.org> said:
>how can i draw a tangent line on a graph with a curve of best fit?
Use algebra in the spreadsheet to construct both the curve and the
tangent, then use an XY (Scatter) Chart type to present them on a graph.
Don't use the built-in Trend Line facility in charts, because then you
won't be able to work out for yourself what the tangent is.
NB Personal replies to this post will send email to de...Ending Balance Problems
I've been having serious problems trying to have my account information show
correctly in MS Money 2006.
I'm doing a fresh install and create a new setup. I log onto my Bank's
websites and download a history of transactions in MS Money format. After
following prompts, the accounts are created and transactions imported.
I cannot for the life of me get the ending balance to show correctly.
In microsoft.public.money, Brian wrote:
>I've been having serious problems trying to have my account information show
>correctly in MS Money 2006.
>I'm doing a fresh...Try catch finally is not recognized by powershell
I am trying to execute a script in Windows 2003 box.
I wrote a sample program to test try-catch-finally test. But it throws
error saying finally is not supported in this version of the language.
Sample program i wrote is below
# Create some explicity typed values
[int] $i = 123
[string] $s = "Some string"
[object] $o = $s
# Now try to convert an object into an integer (which will fail)
# Invalid conversion; o contains a string not an int
$i = [int] $o;
}# catch the error an...VBA Conditional formatting #2
Yes, but can I instead of the color also get
Steven E.'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26812
Take a look at the code at Chip Pearson's site:
"Steven E." wrote:
> Yes, but can I instead of the color also get
> the conditions?
> Steven E.
Hi, I am trying to find a way of determining whether variables (in a large
array of 35000 data points, defined as Single) are actually blank or are
I appreciate that numeric variables default to 0. In my case, I dimension my
large array as single, then set it equal to a range. The range will contain
empty cells (perhaps up to half the time), signifying missing data, but may
also contain data values that are 0. I want to distinguish between these
possibilities. I appreciate that I could declare the array as variant or
string, then test to see if individual elements are blan...Label an average line in a dynamic chart
I have a chart (xy scatter) showing the last 52 weeks of data (it's
accumulated weekly dosage of a medicine - several years worth of data),
i.e. total dose per week plotted against the dates. I also have an
average line (Series 2) charted - it's the average of the 52 y-values. I
did it by creating some 'dummy' values in the data sheet, looking
something like this:
1 12/06/2004 1.798076923
2 11/06/2005 1.798076923
Then the line is constructed from
As a final finishing touch I'd like to have a l...command line switch to open a specific worksheet?
Is there a way to open a specific worksheet in a workbook using command
I'm trying to create a menu selection in AutoCAD that will open an Excel
workbook to a specific worksheet inside of that workbook. Typing the
command "start" <CR> followed by "Excel /filename/" <CR> will open that
particular file, but how do I get it to open to a specific worksheet?
Thanks for any help,
There's no command line switch that will activate a worksheet. You have to
do one of the following:
-Save the workbook with the desired sheet active. Exc...trying to get sheet 1 to recognize and move student names to pg 2
Sheet 1 contains students names in column A in ascending order, columns b
thru k are columns which grading numbers of either 1 point or 2 points,
column l is the total points of colums b thru k.
Sheet 2 contains 5 columns , column a is 17 to 20 points, column b is 13 to
16 points, column c is 9 to 12 points, 5 to 8 points, column d is 5 to 8
points and column e is 0 to 4 points.
I need sheet 1 column L to recognize sheet 2 and move the students name from
column A in that row to the graph on sheet 2 according to the point system
Is this one-time operation?
You have only 5 c...Confidence Interval with VBA
what is the VBA code that will compute the condfidence interval(lower and upper
A confidence interval for what?
> what is the VBA code that will compute the condfidence interval(lower and upper)
...Advanced Filter VBA Help
This is a multi-part message in MIME format.
Currently trying to copy data from one sheet to another. All data in =
column "J" is seperated and a new sheet is added for every unique value =
in column "J". Right now, only the values of the corresponding rows of =
"J" are copied, but I need the formulas and formatting to be copied as =
well. Can anyone give me a heads up on how to do this? Thanks so much
Sub E...Multiple subtotals on a single line
I have a large file that has all of the drugs that our patients have taken
for a period of time. I need to get a subtotal by the drug number (average
cost) and the number of clients that have received the drugs by drug number.
Is there a way to get both the subtotals on a single line. I need to
transfer the data from this worksheet to another sheet provided by
The file looks similar to this.
NDC# (drug ID)
(asst' other columns)
You want to treat the drugid and client# as one field (essentially)?
How about using a helper column:
=a2&"...Deleting Multiple lines
I have a spreadsheet which lists all invoices that are due
to be included in a weeks payment run. Is there anyway i
can set up the spreadsheet to delete multiple lines for
each supplier so all i am left with is a list of all
suppliers i am going to make a payment to that week.
Two ways spring to mind that could help.
i) Create a Pivot Table - In the Data menu there is a wizard -
Highlight the range where the data is and follow the steps.
On completion you will select the values as the data range suppliers as
Rows and invoice date as column heading. This will sum the totals ...