How do you make a combination chart with 2 axis.
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I
put both on same chart?
Plot them both like they would be using the same Y axis.
Select the one that you want on the secondary axis and format the data
series. On the AXIS tab, you can select a secondary axis.
"smw" <firstname.lastname@example.org> wrote in message
> I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do
> put both on same chart?
...Getting value from 2 cols right, 1 row down
I guess this is a simple question but I couldn't figure out how to ge
A B C D E F
1 Worker 100 100 100 100
2 110 110
3 Worker 120 120 120
4 130 130 13
Sheet above is a work schedule and 100, 110, 120 and 130 are jus
predefined work shifts. Row 1 is a morning shift row and Row 2 is
night shift row for the first worker.
Now what I want to do is to create another sheet with workers names t
m...Chart: 2 lines and a bar
I have searched here and in the help file with no luck.
I see it is easy to have a graph with 2 bars and a line because it i
one of the standards already set up.
But I need 2 lines and a bar and I cant figure out how to do it.
I'm sure it is something easy, but maybe this is a brain cramp o
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3061
View this thread: http://www.excelforum.com/showthread.php?threadid=50744
Create line chart based on all three set...Is it possible to have 2 excel version in one computer?
i just installed a 2003 version office... i liked the new features but
when i wanted to open an excel file that has been created by 2002
version excel, i was shocked that i can't open the file successfully.
When i opened and enabled the built in macros in the file, an error
message popped out and said that the data may have been lost. After I
have closed the error message, i checked the file. the data is still in
the worksheet but all the words, format, buttons, and other information
have all disappeared. However, if I open it in another version other
than 2003, the file work...HTML formatting #2
One of my clients sends me email in HTML format, but it comes through in
plain text. I tried going to Format>HTML, but all of the options under
format are unavailable in said email.
Can anyone help me?
...Public Folder Permissions #2
I am having trouble removing or deleting old items from public folders
and calendars. Even the Author of the files or events cannot modify or
remove them. The calendar events that are problems were created months
ago. All users have read write permissions for all folders and
calendars.,Some have Editor or Owner and Author rights. However there
are some recurring calendar items that just cannot be removed or
modified by anyone. Even as Administrator with full access rights I
cannot delete these events. I did upgrade from Exchange 2000 to
Exchange 2003 within the last few months but I cannot s...Cannot create credit card account
I have a credit card account with a bank. I'm trying to set up an additional
credit card account with the same bank, but Money won't allow it. I get the
The service that allows you to download transactions from MSN Money My
Accounts has been disabled. Close and reopen Money. If the problem persists
then try turning the service off and then re-enabling it. If the problem
still persists you will need to re-enable the service with a new Windows
Naturally, restarting Money has no effect. Nor does restarting Windows.
I...Find and Replace #2
Hello, I am facing a problem regarding finding and replacing, i want to
change a value ":10:20" to "00:10:20". Or in other words just want to add a
leading zero before the colon. I have used the wild card to locate the value
but in replce it chages the value with wild card. Please Help me in this.
Find > Replace > Repl;ace what: :1 Replace with: '00:1 > Replace all
Vaya con Dios,
"Muhammad Hassan (New Excel User)" <Muhammad Hassan (New Excel
User)@discussions.microsoft.com> wrote in message
news:89F2F7DB-4DA9-4823-B572-E9D...excel passwords #2
I need to know how to set up a password and change a
password to prevent access to my workbook.TIA
Use workbook/sheet protection.
Select tools menu>protection. There you can select the
type of protection you want and include a password
>I need to know how to set up a password and change a
>password to prevent access to my workbook.TIA
...Order Entry #2
We have set up a password to allow price changes when entering orders
because we don't want to allow everyone access to this field. I have three
customers that request the password even when the salesperson isn't trying
to change the price. I have checked the customer cards of these companies
and I can't figure out why these three produce this message. Is there
something in particular I need to be looking at?
What's the exact message you are getting? Are you sure you are not being
prompted to override price below cost?
Mariano Gomez,...Publisher file #2
I am preparing (as I do every month) a magazine formatted in booklet style.
Whenever I close and reopen, it's turned itself into a web page! I can
reconvert it via Page setup, but when I return to work some more, it's back
in web page format. Any idea why? and what can I do to stop it, please?
Protected by Norton Antivirus
What version Publisher?
Mary Sauer MS MVP
"Lorna Dodd" <email@example.com> wrote in message
news:ulvrWxi...SMTP authentication #2
I have the Office XP (2002) Small Business Edition (it
came with my Dell PC). My Internet provider requires that
I check the option "My outgoing server (SMTP) requires
authentication" in the Internet Mail settings. I check
that option, but when I close Outlook and reopen it, that
option is unchecked. I have reinstalled the Office XP SBE
twice, updated it with all the updates offered in
Microsoft Office Web Page but the problem persists.
This problem started after I formatted the hard disk
because the PC was too slow. Before there was no problem.
Also some of the windows to ...Migrate Contact Address Data from CRM 1.2 to 3.0
We are upgrading from CRM 1.2 to CRM 3.0. In order to migrate the existing
data, we are using the CRM web services (in "../crmservice.asmx"). CRM 1.2
stores the contact data in the ContactBase table; I create a data source,
create an instance of the "contact" object from the CRM web service, set each
of the contact properties from the field values in the DataRows of the
DataSet source, and then use the contact object's Create() method to add each
contact to the CRM 3.0 database -- all of this works very well.
However, CRM 1.2 stores the contact's address d...creating a macro that will paste a value and then move
I am trying to recreate a macro that opens a workbook, goes to Sheet
1, pastes clipboard info into A1, then moves to B1, then saves and
closes the file.
I know how to make the file automatic and how to get it to open and
close (Auto_Open), but I cannot remember how to get the macro to move
from cell to cell (left-to right). What happens is that when I do a
recorded macro and then try to rerun it; it will paste into A1 and
then will tab over to B1. Then upon the next time that I call up the
spreadsheet, it will even paste to B1, but will not move further from
I then...MB5-537 Test:
anyone care to share with me the expected questions for the MB5-737 test for
POS Store Operations ?
I’m good in the system and I’m planning to apply to the test soon.
Hi, If you've been using the system on a daily basis and would consider
yourself good with it, you won't have any problems at all. Now that said, I
still go blank occassionally with the more complex aspects, but you won't get
asked about these on the exam. I got 97% and 98% on Store Ops and HQ
> anyone care to sh...XML serialization problem #2
I'm a .NET beginner and I've got a problem on a program where I try to do an
I get the following error :
"An unmanaged exception of type 'System.IO.FileNotFoundException' occured in
Additonal information : the file or asssembly named n9gu4-bo.dll or one of
its dependencies cannot be found"
Here is the code :
(I've uploaded the complete project at this url
public class Form1 : System.Windows.Forms.Form
TextReader reade...Recievable transaction inquiry slow
When I click inquiry(receivables transaction inquiry), it runs too slowly.
Only this inquiry, others work fine. It happened from last week. My Sql
server had crashed before this happened.
I thought something wrong with the table rm00401, i reindex this table. But
can not fix it.
Who knows how to solve this problem?
Are you running SQL 2000 or SQL 2005?
When you re indexed did you drop and re-create or just use the dbreindex
command? Drop and re-create is the best method for rebuilding an index
completely but it's best to do this when users are log out and it...SQL Optimized
Integration Manager - SQL Optimized - GL Transaction Adapter only allows
functional currency transactions to be integrated. To integrate Multi
currency transactions you cannot use this and have to use the standrad
adapter, which is extremly slow.
...HTML Signatures #2
We are creating signatures for all employees and using a
template it has to be html, can't use a simple GIF. Is
there a way to embed the graphic into the html file or
into the e-mail itself so whenever it is sent it isn't
being sent as an attachment?
You can use a little bit of CGI as part of the employee's signature.
This CGI can retrieve the HTML from a Web server. For instance, you
could have a signature like:
Then yo...Access 2.0 to 2000 or XP
Has anyone tried to convert an Access 2.0 database to a
2000 or XP database. I tried it and I also modified all
of the code that seemed to be incompatible, it works, but
it still acts like there are some bugs. When clicking on
the icon it will open, but after closing once or twice
that same icon will start showing the properties instead
of launching the program or highlight other icons around
it and open other files all at once. I'm running windows
2000 pro and the database I need to convert is still being
used daily. I've tried importing the tables and reports,
converting, ...Money 2007. Transaction Download and Bill Summary Tool Conflict
I think I'm looking for some best practice advice on the use of MS Money.
Currently using Money 2007. I bank and billpay with NetBank.
I use the Money Bill Summary tool to schedule reoccurring payments and
transfers, but I make these payments using the Bill Pay feature of my bank's
website. When I run the Money Update Online Information tool to download
cleared transactions, it does not match the Netbank payments and transfers
with the Bill Summary tool ledger entries. This results in duplicate entries.
I could stop using the Bill Summary tool, but I would still have the prob...add another lane to microsoft pos 2.0
Im having trouble connecting the second lane to the database. We have
the port set correctly but it then ask for a administrator name and
password to the computer with the database on it. I put the
administrator name and password but it says its not correct. Can
anybody help me.
This is probably the administrator name (usually "sa") and password for the
sql database, are you using these and not the ones for the pc?
> Im having trouble connecting the second lane to the database. We have
> the port set correctly but it then ask...How can I create a report of 2 pages in access?
I want to create a report for each record, but i want a two page report. I've
try to do this but it just goes completely blank. Can anyone help me?
Put a Page Break control (from toolbox) at the bottom of the detail section
after all your data.
"Melz" <Melz@discussions.microsoft.com> wrote in message
>I want to create a report for each record, but i want a two page report.
> try to do this but it just goes completely blank. Can anyone help me?
&q...How do i number a template so that it will increase 1,2,3 etc?
Like the date. so every time i open a new one the numbers will increase eg: 1
Dreamworks, have a look here,
and if you are new to macros you may also what to have a look here on
getting started with macros
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
"Dreamworks" <Dreamworks@discussions.microsoft.com> w...import pst file #2
yet, another problem with importing a pst file:
When I have chosen the file to import I get the message:
'Properties for this information service must be defined
prior to use'
But I cannot find anywhere to define it when importing???
I obviously made a definition naming the pst file when
exporting it. But how do I import the file?
How did you create this PST file? Was it ever on a CD? If so, remove its
read only attribute.
"carsten" <firstname.lastname@example.org> wrote in message