Does anyone have an Excel spread sheet for tracking 401 k account.
look in templates at the microsoft office site.
"email@example.com" <firstname.lastname@example.org@discussions.microsoft.com> wrote in
Gord Dibben Excel MVP
On Sun, 13 Feb 2005 17:42:53 -0500, "Tom Ogilvy" <email@example.com> wrote:
>look in templates at the microsoft office site.
...Dynamic Bar of Pie Chart: Series1 Label & Value Issue
I have created a Bar of Pie chart and everything works great. I even have
named ranges on my data so that the bar portion automatically updates when
the data changes. However the Series1 Label on the pie itself does not
change to reflect the new total so that it is the sum of all the values in
the right column below. Does that make sense?
I have one series and my data looks like this:
The pie portion has Contracts & Other as labels with the totals of...Exchange Developer Edition
I have a copy of Exchange 2000 Sever Developer Edition that was part of
Office XP Developer.
Is this a full blown version ?
We have tried to Install it. Actually the installation is not the problem,
can not keep it running.
MTA Stacks fail to run. Other services also fail to run. Clogging up the
Application Log of the Event Viewer with all kinds of
...WinExplorer info to Excel
If I open My Computer (Windows 2000 Professional) in Details View, I can view
the contents of any given folder or drive, with columns for filename, size,
date created, date Modified, Author, etc. My question is, is there any way
to get this information into an Excel worksheet?
I have used another database explorer program (Invitrogen Vector NTI 10)
which has a button called "camera" which does this.
Thank you for your time and attention
You can do it if you want to use "DOS" commands:
Go to "START" - "ACCESSORIES" - "COMMAND...Adding a new line to an existing graph, using excel 2007
I would like instructions on how to add a new line to an existing graph
(that already has 5 lines), using Excel 2007. The data is already in my
1. Right click in the graph.
2. Of the options that become displayed select:-
Select Data . . .
3. Select Data Source window should launch.
4. Highlight the extended range of data you want to include in your graph
(including the new data).
5. Hit OK.
6. The 6th line should get added to your graph.
If my comments have helped please hit Yes.
"...Outlook Hangs on Spam, cannot delete the e-mail
I am using Outlook 2000 on Windows XP.
I received a spam or virus e-mail today that Outlook is hanging on. The
subject of the message is "You will not find Pres\cription Drug#s cheaper
anywhere else" Please notice the backslash and the pound sign. That might be
causing the problem?
When Outlook is opened it immediately goes straight to this message since it
is the last one received and there is no way of getting rid of it apart from
shutting down Outlook. Restarting Outlook does not help. I even tried
starting Outlook with the /nopreview option but Outlook still hangs. Then I
tried...how do I get more than 19 bars on a bar chart
Hi! I have three columns of data each containing 84 entries. These are
grouped in threes, and I wish to create a bar chart to show the comparison
between groups A, B and C.
I use the chart wizard, create a bar chart, then create the series. Then
for each series I go down the column with CTRL held down, selecting each
third entry. This is fine for 19 entries, but when I click to select entry
no. 20, the series clears itself. If I highlight 20 entries and then click
on Insert/chart, I get the message 'Series formula is too long'.
Can anyone explain please how to over come t...Import excel into RMS
I need to import excel file into RMS is the only way thru EMS, or is there
You can download the "Quicksell Import Tool" from the downloads section of
http://www.jeanholland.com - you have to create an account, but it's free.
The quicksell import tool is an UNSUPPORTED tool that MS released several
years ago. You can use it to import Items, suppliers and customers. I
tried it once and found that it was easier for me to just load the files
directly into SQL Server and move the data around from there - but I'm a SQL
A lot of people seem to like...Images in Excel 2000
I'd like to import an 8 1/2" x 11" jpg image into an exel 2000 spreadsheet
and be able to enter data into the cells and still see the image underneath.
Is this possible and how do I do it.
This would be impossible or nearly so using Microsoft Excel. You could do it
However, I think it's crazy to try it under any circumstances.
"cjones" <firstname.lastname@example.org> wrote in ...VB Scripting/Macro
What VB code will allow me to rewrite just the worksheet reference in a
function/cell reference. For example it says
and I would like a macro that would change it to
Any suggestions would be greatly appreciated!!! :)
I have 12 cells in a row that each refer to the same cell location on twelve
different worksheets within the same workbook.
The fill function does not "fill" the worksheet reference. It is too time
consuming to manually input or edit 2016 cells.
you may have a look at the INDIRECT function for this
...Date chart formula question?!?1
In a very old spread sheet i was using this formula
=IF(OR(AND($D7<G$6,$E7>F$6),AND(F$6>=$D7,F$6<=$E7)),".","") and it worked for
dates pre 2009. However, i now wish to use it for dates between 2010 - 2011.
Each column represent a week and the rows will indicate and project or task.
can anyone help?
There is nothing it that formula that will make it work for pre-2009 and not
for later years.
Perhaps you need to look at your data values?
If you have a problem, you could tell us what values are being fed into the
formula when it works...How change dimensions of data label text box in pie chart?
In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie
chart. I can change the font and allignment of the text within the text box.
But, if the text defaults onto two or three lines, I cannot stretch the text
box out to get the text to stay on one line. Normally, you can pull on the
the little handles on the text box. Is there a trick to this that I don't
This is a deficiency in Excel's charting capabilities. The text elements
seem like regular text boxes, but you are unable to resize or reshape
them. Even VBA can't do this.
I am generating large amounts of data that need to be analyzed on the fly.
To simplify the problem, consider an Excel workbook that has n number
of data sheets, S1 to Sn. Each spreadsheet has 5 columns, C1 to C5
and x number of rows, R1 to Rx, in addition to the a header row. The
workbook also has one main sheet called Smain. The workbook should
be capable of doing the following automatically, either by pressing a button
or auto-refresh when the data is updated:
1. The rows of each data sheet should be sorted max to min according to C3.
2. If the maximum value in C3 of a given sheet...excel Hyperlink question
Is there a way I can have a spreadsheet that in one column on a particular
cell there will be a hyperlink to a word document?
Under the Insert Hyperlink menu, I think if you select the "Existing File or
Web Page" button and point to what you want, that should do it.
"Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
> Is there a way I can have a spreadsheet that in one column on a particular
> cell there will be a hyperlink to a word document?
Is there a way the hype...Excel properties
I'm having a problem running a Word macro which mailmerges data from an
excel file I get sent regularly. This only started happening recently.
I noticed that my macro runs fine if I open the Excel document then 'save
as' the same name. Looking at the properties within Excel I see the original
has nothing under the general tab and the archive box is unticked. The
resaved document has all the 'type', 'location', 'size' etc data as you
would expect, plus the archive box is ticked.
Anyone know what's going on here then?
...Getting data point from an accel chart
I have an excel chart that I want to get the data points(x,y) from.
The source data refers to cells in the same sheet, but I don't see any cell
in that work sheet. Only the chart.
I can run the cursor over the line and get the x,y coordinates for each point.
I would like to copy the x,y values, to reproduce the curve in another program
...macro in excel 2007
I was able to access the macro trust level. My excel has customized form
fields that don't show unless I populate the second options, what is the
third option, will it let the fields stay available so I don't have to
populate everytime? I have a trusted source.
Without seeing the actual macro code (assuming that you issue is controlled
by code and not by worksheet protection) then I don't think it is possible to
answer your question.
You probably should talk to whoever set up the worksheet.
"access the macro trust level" only allows you to decide wheth...Import Budget into GP v.10 from Excel
This is a multi-part message in MIME format.
I am having an issue and have followed the following but it still does =
Error message when you try to import a budget in General Ledger in =
Microsoft Dynamics GP: "The number of periods for the budget does not =
match the number of columns in Excel"
View products that this article applies to.
-----...Filtering Excel 2003 Charts to a date range
I have multiple charts that we look for trends on over 1-2 year time frames.
Is it possible to have a chart show all the data that has been entered and
when looking at the chart have a date range data to format that range
differently. What I am trying to do is we have weekly or montly meetings, in
these meetings I would like to show all the additional data differently that
has been added since our last meeting, while showing accumulative data in a
The easiest way to get different formats is to use different series. If you
had one series, you could use autofiltering to...Trying to automatically import specific data from Excel into Word:
Thanks in advance for anyone who can help me with this:
I'll start by explaining the spreadsheet I created in Excel (an inventory /
It is pretty simple; approximately 12 columns. The key column is the item
number / UPC / bar code number, then after that there are various information
columns including item name, description, condition, picture links, etc.
Secondly, I created a template Microsoft Word document that is relatively
long, but will have a few lines (give or take...about 7) customized for each
item on the inventory.
What I am trying to d...Outlook hangs on start
I'm beating my head against a wall on this one.
When I start Outlook, it hangs for about a minute and then tells me it
can't open the default folders. There is no outcmd.dat file since it's a new
install (I looked). It won't open in safe mode either. I also upgraded it
from Office 2000 to Office XP and I still the same problem.
I am connecting to Exchange 5.5 from Windows XP Professional. As I said this
is a fresh OS and Office install so I don't see why this is happening.
Any help is greatly appreciated,
...Select buttons pasted into Excel
I pasted a table from my investment account into Excel. The tabl
included option buttons. I can get rid of the alpha/numeric part of th
paste but the buttons remain.
I've tried to format & copy empty cells but the button remains. I ca
turn on the button -- nothing happens that I am aware of.
How do I get rid of it?? Delete or clear doesn't work.
jzemanek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1463
View this thread: http://www.excelforum.com/showthrea...Hide one month in a chart
I have data from July 2006 to January 2007 that I need to chart. The
only catch is that there is no data for Dec 06 (we do not capture this
data due to the Xmas rush).
On the chart I would like to remove Dec 06 but have not succeeded. Any
In the cell where the Dec 6 data should go type =NA()
This will display as #N/A
Excel will ignore it when it charts
But Dec 6 will still be on the x-axis (it would be misleading to not have
Bernard V Liengme
remove caps from email
<email@example.com> wrote in message
news:1170456927...Perserving secondary axis in pivot chart
I have a Pivot Chart with two series of data, one of which is plotted on the
secondary y axis. Every time I refresh the chart, it defaults back and I
lose my secondary axis. I then have to manually change this every time.
This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
> I have a Pivot Chart with two series of data, one of which is plotted on the
> secondary y axis. Every time I refresh the chart, it defaults back and I
> lose my secondary axis. I then...How to get an excel doc not saved as "Read Only"
I'm trying to figure out why my Excel doc saves as "Read Only". Is there
something I can do to prevent this in the future?
Try File>Properties>General tab and see if Read Only is checked.
Sincerely, Michael Colvin
> I'm trying to figure out why my Excel doc saves as "Read Only". Is there
> something I can do to prevent this in the future?
Some additional items to work through:
Read-Only in Excel, Problems with
David McRitchie, Microsoft MVP - Excel ...