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.
> ...how to set a dialog always topmost
I design a desktoplock program. When a default idle time is expired, it
will pop up dialogs. One dialog is full-screen picture, another is a child
dialog to input password. I implement the full-screen dialog always topmost
by using the function of "SetWindowPos".
Now i find that the function can not make that user's focus is always
topmost. for example, if i open "MyComputer" and double click "Local Disk
C:", then I create a file in C:\. When inputting filename, i stop my action
and idle to let desktoplock dialog popup. In this situatio...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...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...how to read values in this xml file?
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="3.5" DefaultTargets="Build"
I am using the following code to read the value in the <ProductVersion>
tag ...pop3 settings #2
can anyone tell me what settings do i have to enter in
order to receive my yahoo mail to outlook mail?
The version of outlook is 2002
It's not a free service; you have to pay for Yahoo POP3 access. If you are
paying them for it, or would like to, go into Yahoo Mail Help and look for
the section regarding POP3 access.
There is also 3rd party add-in that may work for you -- look here for
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgro...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...Word Count when saving large documents
On some large documents, but not all, there is a verrrry long delay when
saving the document as it repeatedly recalculates the number of words in the
document. Is there a way to turn off the Word Count function in such
Software Support Specialist
Getting the word count is almost instantaneous - and doesn't rely on the save process for an update. If you're working over a
network, the *network* may be the cause of the poor performance.
[Microsoft MVP - Word]
"...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/
...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...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...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 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?
...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...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 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.
...Save as Problem
I have a 20 page marketing guide that built in 2003
version. I try to save in the 2000 format but it locks up
my pc every time. Is there any way to do this effectivly?
Is there any way to view the document on an older version?
Does the problem occur if you create a Newlsetter print publication right out of the design sets in Pub2003, then try to save that
as a Pub2000 file?
I'm just wondering if this is a file specific issue, or happens right across the board.
If the problem even happens with the template, we're likely looking at some interference (such as a 3rd party app) in yo...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...Chart w/two different data sets
I have a set of data which is an set of data points taken through out
a 24 hour period.
The sets are broken up into 3 sets (10 hours, 10 hours, and 4 hours).
I'm trying to create one bar graph which combines the 3 sets into one
24 hour x-axis.
I'm having problem getting the data ranges set. How do I select data
ranges from 3 seperate areas?
I can reformat the data but I need to do this with a lot of different
data sets. I'm trying to set up the graph once and reuse it multiple
Just checking: You have three sets of X and Y data? One goes from 0:00 to...