?-Change data series range as data is entered?
I have a chart which shows a prediction curve and an actual curve. The
prediction curve runs out until the end of a project. The actual curve
is populated as data is entered. I will be generating a number of these
charts from a datatable. I would like to plot the prediction curve for
the duration of the project (easy). I would then like to plot the
actual curve with only the existing data and not have the line drop to
the x-axis at the end. Can I put a formula in the data series "x
I hope that my description makes sense.....
We have had CRM 3 running for about 1 month now with no problems. One of my
colleagues started messing around with CRM Mobile, and since then we have
major authentication issues with CRM 3.
Some users can log on as normal via either the web client or the Outlook
client, while others get a login prompt and their credentials are not
accepted at all.
IIS is set to integrated for crm, they have user accounts within crm and the
restricted access box isn't ticked.
Anybody seen this before?
I am currently using Microsoft Publisher to maintain a website for a
student organization. Ever since I got the file from the previous web
admin, I have had issues saving the web page; publisher is constantly
freezing when I try to save changes I have made. Publisher will
eventually unfreeze itself and correctly save changes to the publisher
file itself, but now every time I tell it to publish to web, Publisher
freezes at the step where the little window with the file folder
transferring files to the globe and whites out. I then have to close
and reopen the program, but after checking the s...Chart series #2
Hello! I have previously posted questions in this field but I have never
gotten an answer. I really really need help with this. I have never
programmed before and now I am supposed to do this VBA application for Excel.
What I want to do is simple enough but I have trouble implementing it and
since and really do not know anything about programming I do not know what is
wrong. The problem is that I am supposed to replace the existing series for a
chart with new series. I have the new series but when applying them to a new
chart it does not work if I have not manually erased the old chart ...How to track 401(k) loan
I'm trying to track a loan i have against my 401K. I can't find any
information on the correct way to do this. Anyone have any suggestions?
There are probably several ways this can be done. Try reading
http://umpmfaq.info/faqdb.php?q=2 for an industrial strength version..
"Rob Cork" <email@example.com> wrote in message
> I'm trying to track a loan i have against my 401K. I can't find any
> information on the correct way to do this. Anyone have any suggestions?
Dick Watson wrote:
> ...Loan Amortization Schedule
I want to know how the payment, remaining balance, Interest and all of those are calculated on the Loan Amortization Template. But the cells are locked and I can not see how they calculated them. Is there any way to unlock the cells so that I am able to click on the cell and see how they did the calculations
You may try to copy them and paste onto a new spreadsheet -- It worked for me I copied the whole columns then pasted special -- widths, pasted special formats, and paste all -- and I was able to access every cell and formulas.
I don't think the template is password ...Mortgage or loan proceeds?
I am setting up a mortgage as a new liability account, but I don't find any
matching entry for the proceeds from the loan when I do. In Money, where
has the money gone or how do I set up an account called 'house'? Can the
loan proceeds go into a checking account? I know how to distribute funds
Help is not much use to try to tie the new asset with the new liability.
Money is very unhelpful as regards accounting for the cash flow at
origination of a loan. There is a workaround--see the last two paragraphs of
http://umpmfaq.info/faqdb.php?q=86....Interst Only Loan Setup in Money
Does anyone know how to sep up an interest only loan in MS
Money? We have a new mortgage that is interest only, and I
want to set it up as a liability, assest account and in
If you set it up as a loan account, then you would set the balloon payment
equal to the value of the loan. In a liability account scenario, then you
would just assign interest charges against the loan (being balanced out by
the payments you make)
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Mone...HELP- Copy a Data Series to Other Graphs? #2
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
Out of the blue for some reason, when I recieve a task, and I click accept
nothing happens. I'm not sure why..
i'm running windows 2000 TS and Office outlook version... 2003
Any thoughts are appreciated.
Yes, task requests are apparently broken if you applied the January =
Outlook security update. Stay tuned.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
http...Changing Start Date for a Loan in Money 2004
I am trying to include last years payments in a home loan but
Money 2004 wont let me change the start date earlier than
1-1-2003 - not sure why - I have also deleted the loan and
reinput it trying to use a 2002 start dat - again it doesnt
allow me to go back that far to start the loan. Do I need
Money 2003 to do this? or is there any wayto change the
start date without getting the error message?
You'll need to set the system date to sometime last year, and then you'll be
able to add the start date. Once you're happy, reset the date. Don't forget
to take a backup first,...Broken site
We had a sub site that was working fine (training schedules template
from MS). The one day we just got 404 whenever we went there.
The site is listed in the collections structure and content and can be
seen in stsadm -o enumallwebs but we can't browse to it.
After giving up on everything I exported the site to a bak file and
deleted the sub site. I confirmed the site was gone.
Then I created the site again. Same name and url. After the "creating
site" page we are redirected to the new site and get the 404 again!
I thought maybe the template was broken so I created...series coloring inconsistent across charts
series coloring inconsistent across charts
I need to keep coloring scheme consistent across several graphs.
Let say I have 6 graphs:
and three barcharts
On all three radars series (colored lines) are built on columns with values
(rows) being located on spikes. all three radars show the same graphics, the
only difference is that only one of them ("starplot") has some colntrols to
hide/unhide columns and "starplotchartwhite" has white background.
each barchart shows values of a si...Broken Exchange Information Store
I do support work for a small company, 8 users, on as needed basis.
Their system is exchange 5.5, NT-4 service pack 6.
On Friday, someone tried to email out a 190 MB video file. Something
crashed and the information store no longer starts.
No viable back-up exists.
I have backed-up the priv.edb and pub.edb and tried using eseutil to repair
and defrag. Priv.edb starts at 2.3 GB and defrags to 480 MB; Pub.edb
starts at 480 MB and drops to 117MB.
Program found errors and reported corrections.
Isinteg aborts running any and all tests.
I have never had trouble with Exchange before so I...Broken Loan Series?
My house loan payment some times gets out of sync with the bill payment
series. (I think Money occasionally misses the match after downloading my
bank statements, and I don't catch it.)
When this happens, I need to delete a payment in the Bills & Deposits list,
since it shows past due.
Occasionally (twice now) when I do this the loan changes from a Category of
Loan Payment (tied to my loan) in to a Paycheck!
If I edit the bill series, the splits don't add up to the total (they sum
the wrong way, so the Unassigned is twice the loan payment). No matter what
I do at this pa...Add Calculated Series in SSRS not there
Desperately need help with something very simple! I'm working with SSRS 2008
in my Visual Studio 2008. I would really like to use the functionality "Add
Calculated Series" when I right-click eg. Sum(Value) in my chart. Problem is,
there is none?! Anybody encountered the same issue?
...How can I make a Chart data series treat blanks as "Empty" cells
My Data Series contains blanks as the result of formula calculations. The
location and number of blanks can change with each recalculation as input
criteria change. I can make my Chart ignore an "Empty" cell easy enough but
my cells still contain the formula which created the blank ("") cell and
therefore, not truely empty. I want to plot the series, about 7000 values,
without the blanks showing up as zeros and ruining my trendline fit.
Removing those rows is not an option as I have to retain the x-axis value as
place holder on the chart.
Thanks for your help; ...Fix Broken Cell Formula with VBA
I have a cell formula that is damaged each time I run a delete to
remove excess rows before a paste & copy. this formula links to a
cell that is always deleted. So I am trying to repair this formula at
the end of each cycle.
Here is the correct formula:
Here is the same formula after the delete:
I tried to fix this in the code that does the finale copy & paste with
Range("B2").Formula = "=IF(A11=...Pivot Chart
I have to make a pivot chart, but i want to set fixed fill color for every
series (and them to stay tha same when i and or filter some data in the
Tel. (54-11) 4792-8757
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
XL2000: Changing a PivotChart Removes Series Formatting
ht...different color for scatterplot with 1 series
is there a way to plot different colors for individual points on a
scatterplot with only 1 series?
my data looks like this
x y time
I would like to distinguish the color of the points by the time, e.g.
anything between 8am - 5pm one color and everything else another
color. I know you can do this with two series if I create a series
with time that's 8am-5pm and another with the other data. I'm
thinking I would need to program using vba, but not sure where to
Jon tells all at
Bernard V...Microsoft Visio Partner Webcast Series
Tuesday, October 17, 2006 - 9:00am - 10:00am PST.
presentations by Zynium and Visual Network Design Inc. - Makers of
This month's Visio Partner Webcast will feature two partners with
solutions that integrate with Microsoft Visio in the areas of Business
Process Management and Data Center Modeling/Management.
Click here to register:
...Loan with insurance
I have a loan that is calculated with the following method;
There are two monthly loan insurance fees
Each insurance payment is based on a percentage of the
principal. 0.00061 and 0.0093
The insurance payments are calculated based on the latest
principal, and then added to make a new principal, and
this new amount is used to calculate the amount that goes
towards the principal balance and the loan interest. This
is all based on a fixed monthly payment.
How do I set this up in microsoft money?
You can't directly unfortunately. I'd recommend t...Student Loan
What is the best way to create a student loan in Money 04? None of the loan
types seem to match a student loan.
Some derivative of credit card seems to work best for most people who have
asked this question. You can just enter the interest from your statements as
new expense transactions.
"Adrian Walters" <firstname.lastname@example.org> wrote in message
> What is the best way to create a student loan in Money 04? None of the
> types seem to match a student loan.
I'll give it a shot. Is this something that is goin...How do I create a broken X axis in Excel?
I would like to create a broken gap in the x axis of xy (scatter) chart in
order to reduce the portion of unused data in the chart along the x axis.
Apply this technique to the X axis:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"TSW" <TSW@discussions.microsoft.com> wrote in message
>I would like to create a broken gap in the x axis of xy (scatter) ch...Pie of pie chart with 2 data series
I am trying to process the results from a survey. For a particular question,
the surveyed people can answer with (say) yes, no or partially. They also
can justify their answer, with (say) something like cheaper, simpler or
don't know. I would like to have a pie chart with the yes, no and partially
answers to see how many have responded with each choice, but then also a pie
of pie chart with for the yes answers (for example) the distribution of the
Here's what I have done so far (this is just a proof of concept with a very
small data set). The headings yes/n...