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...downloading PPT templates from Microsoft
when I click on get "More themes from Microsoft Online" I am taken directly
to the page; but told I don't have PPT 2007 installed in my computer or I
need the newest DirectX. I DO have 2007 installed (as a single piece - I
also have the 2003 suite); and I have upded the DirectX and the downloads
still don't work. Any thoughts?
Along the same line, every time I start PPT 2007 my computer tries to
install PPT 2003 - and this is really a time-consuming process to make it
stop - I usually have the best luck with task manager and "end program" -
but t...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...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...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...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, ...Unable to use Microsoft Outlook
I'm using a Dell 4700C, Windows XP Professional, Internet Explorer 6.0.
I am unable to send or receive mail in Microsoft Outlook.
Thank you for your help,
"meadow" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I'm using a Dell 4700C, Windows XP Professional, Internet Explorer 6.0.
> I am unable to send or receive mail in Microsoft Outlook.
> Thank you for your help,
tis is a little bit less information to help you.
What Outlook version?
Do you use Excha...Microsoft Outlook is hanging.....not responding. Re-install?
Just installed Outlook. Had outlook express before.
It just hangs. Cntrl/Alt/Delete shows it "not responding"
Should I uninstall it and re-install?
Uninstall/reinstall just recreates the same problem. Do you have a mail
account defined? A mail profile? When does it hang? What version of
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, CaroleLynnae asked:
| Just installed Outlook. Had outlook express befo...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" <email@example.com> wrote in message
news:firstname.lastname@example.org....Why do I get 2 copies of a task in the task bar?
When I drag an email from the inbox to the task bar on the bottom left and
drop it into the task list and save it. I get 2 reminders in the task list on
the to do do bar on the right. I did only get 1 as you would expect and then
I must have changed something but I do not know what. Can anyone help please?
"andrew" <email@example.com> wrote in message
> When I drag an email from the inbox to the task bar on the bottom left and
> drop it into the task list and save it. I get 2 reminders...Microsoft Outlook 2002
In Oulook 2000, in the e-mail options, it was possible to check a box to get
the people you replied to automatically added in your contact list (i.e.
address book). I cannot find this option in Microsoft Outlook 2002. Has it
been removed??? It seems silly that it would have been removed - it was
Please help! Thank you.
Melanie <Melanie@discussions.microsoft.com> wrote:
> In Oulook 2000, in the e-mail options, it was possible to check a box
> to get the people you replied to automatically added in your contact
> list (i.e. address book). I cannot...Please verify BUG in Microsoft Windows XP/2003 Accessibility *MPS* #2
The Problem (Multi Processor only):
This occurs when there is MORE than one Logical/Physical CPU on the
When a console winevent hook function is active, changing the codepage
of a console window causes the console window to not respond.
I set a hook using SetWinEventHook to get notified on events
EVENT_CONSOLE_CARET to EVENT_CONSOLE_END_APPLICATION
all is well, events are coming.
When I open a CMD window and change the codepage to a different
codepage than the default one, the window stops responding.
>From my tests it appears that the problem is somewhere in the