Printing Graphs in Money's Retirement Planner??
I don't often print my retirement planner from Money, but today I found
need to while in the offices of a financial planner. I was surprised to
find that no matter how I tried to print (FAX, Adobe PDF, direct to
laser printer, Microsoft Office Document Image Writer), the planning
graphs would show up as empty space on the printed page.
I am pretty sure this used to work. It's not working now. Have I
turned off some hidden function which says "do not print graphs", or is
there some other fix to this?
...open at define work sheet
Iwant a shared workbook to always open at a define work sheet (Front page).
I have entered the following in vb under workbook but it does not work. I
entered the following
Private Sub Workbook_Open(sheets "front page".select)
Put the following code in the ThisWorkbook code module:
Private Sub Workbook_Open()
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"kit" <firstname.lastname@example.org> wrote in message
news:3FD800CE...How do I display a custom date range for a graph in a report?
I can display a custom date range in my reports, but if I add a graph it
goes into a loop when prompting for the date range. I have also tried to do
the graph without the report but instead of showing the date range it shows '
#Name? ' where the date should be. Does anyone know how to get around this?
Thank you, Diana
I want to increase font size of name 's sheet.
What should I do?, Can you help me?,,Pls
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=38f461ab-99f6-47aa-b5ea-15e79e3d27c2&dg=microsoft.p...Moving data between Excel sheets
"I have an excel spreadsheet that has 2 sheets, one has a list of open
issues" and one a list of "closed issues". One of the fields on the "open
issues" sheet has a "closed date" field. Whenever a date is typed into this
field, I would like for it to be moved to the "closed issues" sheet, to avoid
duplicate, manual entries being done. Can anyone help me with the best way to
achieve this? Can this be achieved by using Macro's.
Any help with this, would be greatly appreciated.
Suggest you send this to the programming newsgroup...Is there a template for creating math practice sheets for add, su.
I want to create a practice sheet for specific tables (like 7's, 9's), and be
able to get new problems and have answers.
...Prinding each row of Excel sheet on a seperate page dispallying one record on each pa
From a spread sheet ,I need to print out a row on each page seperately
that is printout each record on the row on one page seperately.
Can any one please advise how it can be done ?
Row 1 Data 11 Data 12 Data 13
Row 2 Data 21 Data 22 Data 23
Row 3 Data 31 Data 32 Data 33
I would want to print out Data 11 and Data 22 on one page
then Data 21 and Data 22 on the second page and data 31 and Data 33
on the third page
Pleae advise if and hwo this is possible.
Message posted from http://www.ExcelForum.com/
Sorry ...show value as percentage in stacked bar graph
I work for the Court and I am trying to show the percentage of 2 types of
cases (CC and SP) to the total judicial caseload, in five different separate
locations, on one graph. I developed a stacked chart which shows the values
(number of cases) of each type (CC or SP) per location. I was also able to
also show the value only of the total number of cases (CC + SP) and keep the
original chart format without adding a third stack on top by entering a third
series as the total value, but making this series transparent and aligning
the total value at bottom of stacked series of CC & SP...road graph
Please have extra patience for me please, i am very new for charts.
from access data base with fields
:-100,150 etc any number],[curves:-in degrees],[curve_direction:-left/right].
i want to show 3 factors over the graph between two said kilometers
(1) city lies between two said kilometers as text boxes
(2) the geography of road between kilometers like road raising / falling
(3) curves left/right
up and down i can able to show but i could not...I would like to compress the x-axis of my graph
I would like to remove a section of the x-axis of my graph to read so that
the axis reads 0,1,2,3..........10,11,12,13 instead of
"red" <email@example.com> wrote in message
>I would like to remove a section of the x-axis of my graph to read so that
> the axis reads 0,1,2,3..........10,11,12,13 instead of
...Stacking Single Bar Graph
Need to find a graph that stacks a series of values in one bar. I know that
the stacking graphs should work, but I can't seem to figure out how. For
example, $100 total with $25 for Susie, $50 for Bill, $15 for Jane, and $10
for Mark. Each of these need to have separate manipulatable colors and text.
Thanks in advance.
Enter the names and amounts in adjacent columns on the worksheet:
Select a cell in the list, and click the Chart Wizard button
Select the Column chart type, and the Stacked column subtype
On the Data Range tab, select Series ...time sheet template available
I am looking for a bi-weekly time sheet template (or weekly).
Having problems with excel correctly computing total times (works great for
bsydnes, heres one,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"bsydnes" <firstname.lastname@example.org> wrote in message
> I am looking for a bi-weekly time...CVS file only inserts commas for 15 lines of spread
I hava an user in Europe that is following the exact steps I am to
covert a file to CSV format. When we open her file in word pad, only
the first 15 lines of data have comms delimted. It happens every time
regardless of how much data is in our spread.
Any ideas on how to correct this?
I've never seen anything like this.
If they reopen the .csv file in Excel, does it look ok?
If they open the file in NotePad (not wordpad), does it look ok?
My silly guess:
I'm wondering if there is any special character in the data that is being used
as an end of file marker....Multi-sheet totals
I'm fairly new to the "joys" of Excel and would appreciate some advice.
I have a multi-sheet workbook. Each sheet has a cell (the same cell on
every sheet), let's call it "D2", with a "total" for that sheet.
Is there a *simple* way of adding up all the "D2's" in the workbook and
putting that sum on the last page? Ideally I want it to keep adding up
all the "D2" cells, even when I add new sheets.
At the moment I'm using the old =SUM('sheet1'!D2+'sheet2'!D2) trick,
but I'm getting a bit sick of ma...I need .5 instead of .3 on total time on time sheet
I need to make the total time at the end of the week show .5 (39.5 hours)
not .3 (39.3 hours)
What formula? What value of the source cells? What formatting?
Microsoft MVP - Excel
"Anthonyt65" <Anthonyt65@discussions.microsoft.com> wrote in message
>I need to make the total time at the end of the week show .5 (39.5 hours)
> not .3 (39.3 hours)
"Anthonyt65" <Anthonyt65@discussions.microsoft.c...CRM System Tray Icon shows as a black square.
Having installed the CRM Outlook Client for Laptops, the system tray icon was
working fine, but, after a few reboots (but no changes) now just shows as a
black square. If I hover over it, it says CRM CLient - Online as usual, and
doesnt appear to be affecting the operation of CRM at all, its just damn
Has anyone else seen this behaviour? And/or got a fix for it?
I've tried the old de/re install and that's made no difference what so ever.
I finally fixed this by uninstalling CRM, and then manually removing all the
Then a reboot and reinstall, and th...Weighted Avg
I maintain a spreadsheet for a telephone hotline. We track total
number of calls received (column F) as well as average time to answer
the call (column J). To analyze the month's average time to answer, I
use the following weighted average formula: SUMPRODUCT
I have 2 questions relating to this:
1) Is the above formula correct to determine the average speed to
answer? I've assumed the weights to be the total number of calls
2) I have a different spreadsheet for each month (Jan, Feb, etc.). How
can I properly show the weighted average as...need to zoom in a particular region of graph
I need to zoom in a particular region of graph. Please advise.
...Maintenance log sheet for a brush chipper.
How do I make a maintenance log sheet for a brush chipper.My boss wanted to
keep track of when I greased bearings,changed oil,filters and other related
stuff. I have no clue how to start to make this, Please help!
I do a similar thing with my cars. In column A list all the tasks that you
want to log. For each task, when you perform that task put the date in the
cell to the right. When you do that task again, put the date in the first
empty column to the right, and so on. HTH Otto
"cooldog...Trendline on stacked bar graph
How can you add a trendline to a stacked bar graph? Thanks
Joni's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=13596
View this thread: http://www.excelforum.com/showthread.php?threadid=513635
Keep in mind that a stacked chart depicts a sum of one or more series, not
just each series. Trendlines only work on individual series. You could
either generate trendlines for each series on a non-stacked basis, or you
could add dummy line chart series to the stacked column chart...Excel has stopped showing graphs on seperate chart tabs
All chart only worksheets appear as the vacant background (as if no file is
open) yet the worksheet tabs are all visible. Charts embedded in a worksheet
show OK. This applies to all files created or historic 97-2003 type files.
What's causing it and what can I do?
...Misplacement of objects on a sheet
In Excel 2007 when loading a workbook (originally created in Excel 2000),
objects like text boxes, rectangles, etc will frequently be placed on the
sheet in the wrong place. I have posted an example at http://220.127.116.11.
Notice in the "Correct" screenshot the row of buttons. You can click any of
the buttons (which correspond to sheet names) and go to that worksheet. The
current active worksheet ("WA" in the example) is indicated by the red
background text box filling the space of the button (and circled in the
In the "Incorrect" example, notic...MS Excel expense sheet password lost
Hello. i'm trying to edit the a ms excel expense statement/re-imbursement
template. unfortunately, it's password protected (and nobody at work knows
what it is). does anyone know of a program that can crack an ms excel
password or know a way of over coming this problem?
all i want to do is duplicate, re-arrange, and rename the sheets.
check out http://www.mcgimpsey.com/excel/removepwords.html for information
"Wil" <email@example.com> wrote in message
> Hello. i'm trying ...Data is being duplicated on multiple sheets + [Group] in the title
OK - so I've turned something on by mistake and all the data that I've
entered in "sheet2" has been replicated in "sheet1".
The [Group] marker in the title bar is a clue I'm sure, but I have no idea
what I've done.
Can anyone tell me what I've done and how to undo it?
Right click a sheet tab and select ungroup, save the workbook
(No private emails please)
"Nick" <Nick@discussions.microsoft.com> wrote in message
> OK - so I'...how do i set half an excell sheet to now scroll with the rest.
http://office.microsoft.com/en-us/templates/TC010186511033.aspx with that
check book register. the top few lines do not scroll when i scroll teh page.
how do i repeat that option
Select the cell under the row and to the right of the column you want
immobilized and then go to menu Window>Freeze Panes
"greasepain37" <firstname.lastname@example.org> wrote in message
> http://office.microsoft.com/en-us/templates/TC010186511033.aspx with that
> check book register. the top few lines do n...