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" <email@example.com> 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...Changing Domain Name
We have mix W2k & W2k3 DCs and one E2k2 in a W2k3 member server. We now
xxx.yyy.zzz.ca.us as our domain name. Now we have approval to change it to
xxx.yyyyyyyy.gov format. What is the most efficient way to do it? We need
to retain the old domain name with new domain name for a period of time to
give our users enough time top inform their friends, other senders,etc.
JoeCL <JoeCL@discussions.microsoft.com> typed:
> We have mix W2k & W2k3 DCs and one E2k2 in a W2k3 member server. ...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" <firstname.lastname@example.org> 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...Tabs Names
Is it possible to change all of the tabs names in my workbook (using
something similar to "find & replace"??
ex: workbook tabs names:
Q107, Q207, Q307, Q407 (for quarterly reports in 2007)
Now I want to change the tabs to read:
Q108, Q208, Q308, Q408.
Is there a quick way?
Nope. Not without resorting to a macro. Depending on how many sheets it may
be quicker to just do it by hand than to write a macro.
"MDI Anne" wrote:
> Is it possible to change all of the tabs names in my workbook (using
>...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, ...display of text and lines from CAD
In Visio 2007, I opened a .DWG,converted it, and saved is as Visio
Some of the entities (both lines and text) don't display on the screen
in the formatted color.
The current theme is "none".
I tried two other themes, with no apparant difference.
Any idea why these would display (and print) as a different color than
they are formatted?
When I change the font size of the text, it does change size. When I
change color, it doesn't change.
...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...getting column and row names if a cell has a value
I am trying to pull data out of a large Excel spreadsheet to get a
slimmed down version..
I have a large spreadsheet (100+ columns by 500+ rows, and 12
worksheets) that I'm trying to make sense of in order to import into
Each Column has a four-digit code for a "name", each row has a five-
digit code for its "name." The majority of cells have a value of '0'.
I am trying to get excel to look at the range, and if there is a value
that is not zero in a cell, give me the column name in one column, the
row name in the next column then the v...embedded pictures in Outlook 2002 (sp3) not displayed
Does anyone know why the embedded pictures in received email messages do not
appear? Instead, an icon with a small red square, green circle and blue
Are you using Word as the editor?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Sparky asked:
| Does anyone know why the embedded pictures in received email messages
| do not appear? ...