changing a line to a bar in "line-bar graph"
I have 4 qtrs of data and a benchmark set up in a line-bar
graph. when the graph comes up, 3 of the quarters are
reflected as bars; the 4th qtr appears as a line, along
with the benchmark. I want to be able to change the 4th
qtr to a bar.
I need this for a board report - ASAP please
Right click on the series, choose Chart Type from the pop up menu, and
select the chart type you want for that series.
Jon Peltier, Microsoft Excel MVP
Laurie M wrote:
> I have 4 qtrs of data and a benchmark set up in a...Account Format change
I need to add a new segment to my account framework and also increase a
segment length for my existing accounts.
For example: from 10-999, I need my account to read as 30-10-00999 where the
first segment is the new segment and the last segment of 999 becomes 00999.
Will Reformatter or the product from Microsoft do both of these things?
Anyone has experience with this.
I believe you need Reformatter from CRG.
Charles Allen, MVP
> I need to add a new segment to my account framework and also increase a
> segment length for my existing accounts.
> ...Microsoft 2000 saving a file
I cannot save a file to my E: drive or portable thumb drive. I either
receive one of two messages. (1) Word cannot continue the save do to a file
permission error or (2) file or directory cannot be created. I can save to
the hard drive not to the traveldrive. HELP
Sure doesn't sound like a Microsoft Access Database issue.
"Dan" <Dan@discussions.microsoft.com> wrote in message
> I cannot save a file to my E: drive or portable thumb drive. I
> receive one of two messages. (1..."Today's Total Change" doesn't calculate in Portfolio Manager
I've had a problem with Money 2005 and 2006 Deluxe where the Portfolio
Manager does not show "Today's Total Change" for stocks & mutual funds. It
shows it for some, but not others...this is not only an annoyance, but
prevents me from seeing how my investments are doing on a daily basis.
What's interesting is that it shows today's change in the price of the stock
or the NAV of the mutual fund, but Money seems to have issues with
multiplying that by my number of shares to get "today's total change".
I saw a patch for this in Money 2001, but it w...Publisher2003 wont open a Publisher2000 .php file
I have a bunch of files created in Publisher 2000. Now
that I upgraded to Publisher 2003, it wont open the .php
files created by Publisher2000. Any ideas?
..php files are not Publisher files. I believe those are MS's Home Publishing
files. Publisher files have a .pub extension.
MVP Microsoft [Publisher]
"eddie" <email@example.com> wrote in message
> I have a bunch of files created in Publisher 2000. Now
> that I upgraded to Publisher 2003, it wont open the .php
> files create...version changes
i created a business card on Publisher (xp) but when i try to load it onto a
computer w/ a color printer that has publisher ('97) it says i can't load
stuff from another version.
is there any way i can "downgrade" the project to make it compatible with
the older version?
didn't mean to post that twice. see above. ^^^
No there isn't. Copy the file to a disk and hie thee to a print shop.
MVP Microsoft [Publisher]
"Pringles." <Pringles.@discussions.microsoft.com> wrote in message
news:285A2C89-D032-4123-87C0-0ABFF5B652A5@mic...change cell change picture
I'm using cell to display picture, for that, i saw a topic here with this
but the problem is that i'm not getting the pictures displayed, it appears
like example only without picture.
I'm making the connection between picture and cells with INSERT -> NAME ->
someone can tell me how can i do to work it out?
...Prompt for user to change passowrd...
Is there anywhere in setup where we can prompt a user to change their password?
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/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=38427276-d6c5-4b43-8f63-1f1b6e6f836c&dg=m...Change insidewidth property
i need to change the insidewidth property in plot area what size i want. for
ex. if i am giving chatarea.plotare.insidewidth = 200 then it shows error
because insidewidth is read only double. so how to change that value
You can not change the value directly because as the error says it is a
Read-Only property. You would need to change the 2 things that effect
the value, plotarea width and axis labels. But it would be a case of
trial and error.
M Selvaraj wrote:
> i need to change the insidewidth property in plot area what size i want. for
> ex. if i a...How can I deit a Borderart (.brd) file?
I am trying to change the background colour on the torn paper borderart with
little to no success. I have placed this around a text box and provided a
yellowed colour to the text box, but I am presented with a white gap before
we get to the actual black of the torn border - this is sending me insane! I
have searched the World Wide Wait to no avail, is there nobody else that is
trying to do this?
Select the border, copy, paste special as a .wmf (Windows Metafile), ungroup,
click yes, ungroup again, delete everything but the border, you will have to
adjust the corners. Select all, grou...changing page layout
I did a document in publisher in portrait layout, with a picture and would
like to make it a side fold document/
Setup a new publication as a booklet, copy/paste your objects from the older
Mary Sauer MSFT MVP
"chinadoll" <firstname.lastname@example.org> wrote in message
>I did a document in publisher in portrait layout, with a picture and would
> like to make it a side fold document/
...how to change the icon text
What event to I do to handle when my app get iconified? I Need to set the
window text for my icon differently than my app title bar text.
When I run my app, the window text for the app title bar is "foo", when the
user iconifies the app, I want the icon text to be "bar".
How do I do that?
Thanks for the help,
Take a look at CWnd::OnSysCommand. SC_RESTORE and SC_MINIMIZE is what you
want to look for in this method.
Ajay Kalra [MVP - VC++]
"reza razavipour" <email@example.com> wrote in message
news:uK18XkXH...Server Log on changes
When I try to send outgoing email my login iformation changes and I get the
Your message did not reach some or all of the intended recipients.
Sent: 5/22/2006 11:52 PM
The following recipient(s) could not be reached:
firstname.lastname@example.org on 5/22/2006 11:54 PM
You do not have permission to send to this recipient. For
assistance, contact your system administrator.
<mycompany.domain.local #5.7.1 smtp;550 5.7.1 Authentication is
required to send mail as <email@example.com>>
Any Ideas...show ink on an excel file.
How do I show ink on an excel file? It is not highlighted.
Microsoft MVP Excel
"Jean" <Jean@discussions.microsoft.com> wrote in message
> How do I show ink on an excel file? It is not highlighted.
On Dec 4, 2:25=A0pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"Jean" <J...@discussi...Money Updates: "Money encountered an error processing the download file ('SMRTINET.ini').
My M04 has not been doing Money Updates (other parts of update are doing so:
quotes, accounts) for a month now. The Call Summary for Money Updates says
Money encountered an error processing the download file ('SMTINET.INI').
Out of curiosity I looked for such a file name on the computer--none.
We have two accounts on Money. The other account is NOT encountering any
such problem--Money Updates are working fine for it.
No changes for either account of any seeming relevance preceded the loss of
updates on the one account.
(1) Does anyone know how to fix this?
(2) Thes...include gif file in reply
How do I make Windows Mail include a .gif file when I reply and do an
Insert/Text from File,
and the file is an html file that includes a sound file and a .gif file? The
sound works, but WM does not include the .gif file. The source shows SRC=""
and no .gif file name..
You are trying to insert 2 files. Do the text file (just like you
already did), if that works. Although sound files are usually
inserted by going to Format->Background->Sound.
Then do the gif file by clicking Insert->Picture. The picture
should be sitting on your hard drive. It ...Deleting Business Units 02-01-06
Anyway to delete a business unit. I can see how to disable, but how to
delete it would be nice. Thanks, AVC
There is no supported way how to delete a business unit.
> Anyway to delete a business unit. I can see how to disable, but how to
> delete it would be nice. Thanks, AVC
you can disable it but not delete , as well as i can see..........
...money keeps freezing even after Bills deleted and standard file repair.
I have the same problem coming from Money 2006 , which worked fine.. I did what was recomended here , but it did NOT solve the problem. Could not find anything in the MS web about this problem.
...How to change Pivot when SQL data source fieled name changed
Q: How to change Pivot when SQL data source field name changed
I have a Pivot table that accesses a SQL data source.
When one of the Fields Names in SQL is changed there is an error when trying
to refresh Pivot Table.
I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
Name like I can when just using MS Query to import data into excel vs into
Is this possible?
Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source
> Q: How to change Pivot when SQL data source field...How do I move files that are linked with template wizard?
I would like to move the location of an entry form and database that was
created with the template wizard. Unfortunately, when I do this the entry
form cannot find the new location of the database. How can I correct this?
...change chart title with auto filter
I would like the title of my chart to change automatically every time I use
the autofilter function to make a new selection of data to be displayed in
the chart. Can anyone inform me of how to make the chart title change
automatically with each new selection?
See this 'link'
Krishnakumar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20138
View this thr...Change location of PST with IMAP accounts
I am currently using Outlook 2007 and have a question about IMAP. When
using regular POP accounts, you can change the location of the PST by
moving it to another place in Windows Explorer and the next time you
start Outlook it will say the PST is missing and will ask where it is.
Now, when using IMAP accounts this approach doesn't work. When you
delete/move the PST that is associated with an IMAP account, Outlook
will just redownload the mailbox from the server and create a new PST in
the same location (%USERPROFILE%\Local Settings\Application
I didn't f...change default layout view
How can I get my emails to open up with the Print Layout
View as default. Every time I compose a new message or
open one from my inbox, the format defaults to normal view.
I have two grids, and the for one of the grid I have given expand-collapse
And I have used MaintainScrollPositionOnPostback to maintain the position of
All works well, except since when i used MaintainScrollPositionOnPostback
the grid wont remain collapsed on postpback. It expands everytime the page
does post back.
This application is published on sharepoint site.
...Please help with txt file
I would like to save a file as a txt file and then see the tab character when
I open it up in notepad. Anyone know how?
I don't think Notepad will show the tabs.
Can you open it in MSWord and turn on
Tools|options|View tab|Check Tab Characters.
Or you can hit the pilcrow (the funny looking backward P character on the
standard toolbar) to see all the formatting characters.
(to see what icon I mean)
sleepless in san jose wrote:
> I would like to save a file as a txt file and then see the tab character when
> I open it up in notepad. A...