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.
> ...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
I created a document, selected Protection>Protect Sheet, then made it a
shared document. My problem is now the “Unprotect Sheet” selection is
grayed out and I need to make some changes. I am also unable to
unshare the sheet. I would appreciate any info on the issue.
you can't change the protection in a shared document. You first have to
unshare the document. This should be possible in the menu (or save it
as a different file)
"BabyBlueAXiD" <BabyBlueAXiD@discussions.microsoft.com> schrieb im
Newsbeitrag news:21259E03-8...Me.RecordSource does not seem to work in Access 2007
With the following code:
If global_orders_due_today = True Then
Me.TxtCurrentView = "DELIVERY DUE"
global_orders_due_today = False
Me.RecordSource = "Orders for delivery today"
Me.DataEntry = False
Me.AllowAdditions = False
If global_standing_orders = True Then
Me.TxtCurrentView = "STANDING ORDERS"
..."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...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...VBA with Modifier or Dexterity with Modifier
I had to modify a few forms in the HR dictionary as i have to add/remove a
few fields, so i am using modifier with vba to save/retrive/delete data for
I had added a local field to the window with modifier and saving/retriving
its value with VBA, now upon value returning from lookup or navigating
through records each time i am being prompt to save record message box even
though,i havent touched any field, i had put my VBA code on ID field's
Also i lose data and ID if i put delete code on Delete_AfterUserChanged
event so i had to put it on the Delete_Before...Counting words
Can anyone help?
Is there a specific way to count each word in a spreadsheet. (same typ
of word count that you can do in Microsoft Word) Most cells contain
more than 1 word and some sentences.
Diamonelle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1275
View this thread: http://www.excelforum.com/showthread.php?threadid=27281
not really possible. One workaround: Copy your data to MS Word and use
the counting in MS Word
Frankf...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...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/
...Protecting Worksheets and hiding based on password
I did a search on this and got close but not exactly what I was lookin
for. I would like to password protect worksheets within a workbook.
would like the password window to open upon opening the workbook, th
user would enter their password, then the appropriate sheets would b
displayed. Is this possible? I have 3 sheets each for an individua
user and a chart that graphically charts the three users progress. S
when user one opens the workbook they enter their password and se
their worksheet only and so on for all the other users.
Message posted from http://www.ExcelForu...Windows 7 installed Word documents won't open
I installed Windows 7 this past weekend.
I received an email with a word document attached. The attachment will not
open. I get a "An error occurred sending the command to the application".
I did not have this problem with Vista.
I have uninstalled and reinstalled Microsoft Office and that did nothing.
...how can I find excel 2007 tutoring for beginners
Have excel 2007. Never used excel before and need to create an examination
table with various timings for different candidates. I need some basic
tutoring. I only seem to be able to find help for experienced users coming
Use the "Dogpile" search engine and search for 'excel 2007 tutoring for
> Have excel 2007. Never used excel before and need to create an examination
> table with various timings for different candidates. I need some basic
> tutoring. I only seem to be able to find help for experience...VBA Timephased Macro
I am writing a macro to be used in resource usage view. If a user clicks in
timephased grid for an assigment. I need to know which month is he/she
selecting and uptdate that cell in timephased view. Any idea will be helpful.
Please rate this post if it has helped
I have never found a possibilty to get selection information from usage
views. If someone else can tell, I will be happy to learn (and re-write a
As a workaround I use inputbox to get startdate and #columns or finishdate.
"Gau...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]
"...Access 2007 Sharing Data
In Access 2000 I copied the front and back end files and emailed them to my
coworkers all over the US. I enter and control all of the data so it's not a
big deal if they mess something up. How would you suggest sharing this
data in Access 2007?
Thanks for your help
"Fly Boy 5" wrote:
> In Access 2000 I copied the front and back end files and emailed them to my
> coworkers all over the US. I enter and control all of the data so it's not a
> big deal if they mess something up. How would you suggest sharing this
> data in Access 2007?
> Thank...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...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...Reproducable bug with Access 2007 runtime: macro, rename table does not work
I have a macro renaming the table X to A.
This macro works fine when access 2K3 is installed.
With run-time 2007 (and perhaps with Access 2007 also), I don't get any
error message and the rename is done. (Run-time allows me to delete and
import objects, but not to rename?)
The table has no relations.
Can someone tell me if there is a patch/workaround for this? Seems to be
to be a (severe) bug.
It's pretty hard to debug and figure what the problem is with zero
I would probably strongly suggest that you rewrite the code using VBA, and
...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.