Data Series Labels in Area Chart
I'm trying to create a combination chart; one data series in an area chart,
and three in line format. Got the chart created, but the data series labels
for the area chart show up in the middle of the area, which looks awkward.
Is there anyway to move them closer to the top edge of the area plot? I
don't seem to find any options for moving the labels in an area chart.
The data labels for the area series have no options for alignment.
Add another line series to the chart based on the area data. This has
the options to align data labels. You can format the line seri...Advance Security #2
I'm using GP 7.0 on a Citrix Server
When I try to user Advance Security it's telling me that some one else is
using it and no one is using Advance Security. How can I fix this problem?
Also at times while using Advance Security I will get log out of GP. Do
anyone know why this happens?
Great Plains/Great Plains Standard on Microsoft SQL Server/MSDE
1. Make a backup of the DYNAMICS database.
2. Execute the following script in Query Analyzer or the Support
> I'm using GP ...How do I get rid of header/footer on page 2 of document?
the help menu says to click on header/footer, then toggle to new, then
highlight text you want to get rid of, then hit delete key. I did that but
all the header/footers throughout the document got deleted. How do I get to
keep only the header/footer on page 1?
Please see reply to your previous duplicate question.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Fay Zeller" <firstname.lastname@example.org> wrote in message
> the help menu says to click...Copy Pivot Chart
Does anyone know how to copy a pivot chart and paste only its values?
You can copy/paste special/value as you would any other cell values. However,
you need to navigate from "edit" on the tool bar. These options are not
available for a pivot table via the right click.
> Does anyone know how to copy a pivot chart and paste only its values?
...How do I add a data series in a combination chart in PPT 2003?
I have a combination bar/line chart showing gross revenues and passengers by
month over a 3-year period. The gross revenues are bars on the primary
y-axis and passengers are lines on the secondary y-axis.
I am trying to add gross revenues and passengers for CY2010. I am able to
add a data series for the passengers, but when I try to add a data series for
the gross revenues, the chart treats it as a series on the secondary axis as
How do I add the series as a bar on the primary axis, or alternatively,
change the series from a line on the secondary axis to a bar on th...Badmail folder #2
Please can somebody tell me how to read the bounced email
in the badmail folder, I have tried associating them with
outlook and they mail messages are just empty, I have
even tried renaming to .eml. There are three different
extension, which one should I be looking at for email
incomming to a bad address, thank you
You should be able to open these files in Notepad and check the email header
> Please can somebody tell me how to read the bounced email
> in the badmail folder, I have tried associating them with
> outlook and they mail messages are just e...Outlook 2003
Here's the problem: Every tiem I open Outlook it
displays an error message that my Exchange server is
What I know: I know the Exchange server is up & running
without any problems. The desktop computer is on the
network and can browse and ping different devices. DNS
is resolving names properly.
Does anyone know what I can do to fix this?
...how I can sum or subtract 2 or 3 field in access in any record
I want know that why there is NOT any relationship between access and excel
and how I can sum and subtract 2 or 3 filds in access in any record
Hello Hadi -
I'm not sure I understand exactly what you are asking, but Excel is *not* a
'front end' for an Access database. You can use Excel to query the db & copy
Access data into a workbook in several ways. That copy of the data can be
used for calculations, but the data *doesn't* get changed in the Access
file. Although the modified results can be imported to Access it may very
well be t...2 questions regarding count formula
If I have the following data
A B C
1 Personnel group type p't number
2 Melinda 1 4
3 Sean 1 5
4 Melinda 1 6
5 Sean 2 30
6 Fay 3 8
7 Melinda 1 32
1. How shall I contruct my formula to count the number of data that satisfy
the following criteria:
1. personnel is Melinda
2. group type is 1
3. ...Selecting the font size matching the control's height
I have an array of labels, which height changes in relation to
the form's height (form is resizable).
What will be the best method of selecting the labels caption font size?
On 7 Feb, 04:46, "Claire" <replyto@fra> wrote:
> =A0 =A0 =A0 =A0 =A0 =A0 I have an array of labels, which height changes i=
n relation to
> the form's height (form is resizable).
> What will be the best method of selecting the labels caption font size?
Might be an answer here http://www.dreamincode...Org Charts
I have 5 people that report to the same person and currently they all show on
the same row, the owner of the company wants the 3 VPs to show directly
underneath him but the remaining two to have their line drop down lower than
the 3 VP's. IS there a way to do this? Everytime I try it just makes the
box bigger for all of them.
Are you doing this in Excel? Which version? Which tool the Diagram tool or
the AutoShapes tools?
> I have 5 people that report to the same person and currently they all show on
> the sam...comparing componants of tables #2
I cannot easily compare data elements of comparative data. Here's
what I mean,
bill jones mary Dee
observation 1 observation 2 observation 1
observation 2 observation 1 observation 2
weight 160 155
128 119 120 129
belt size 40 38
29 28 25 26
shoe size 12 11
8 9 8 9
But, I ha...My (final) 2 cents on continuous form design
Some days ago I started a thread on this forum regarding the design of a
continuous form to be used to show all of the records filled in a table and
giving the possibility to the user to select each row and perform action on
the record (mine is retrieving all of the information from the record and use
them to fill another form where the data can be edited). This can be easily
accomplished through regular continuous form but I stated few requirements:
a) the form should be unbound and the data should be not editable;
b) I hate having that crappy effect of all the text selected whe...Operation Failed! #2
Using Outlook 2002 and when attempting to Send/Receive mail I get an
immediate error message saying "Operation Failed!" There's no attempt by the
program, no timing out - the error msg. pops up immediately. I've tried
deleting and reinstalling the mail account to no avail. I'm stumped!
Thanks in advance!
Create a completely new profile to see if that solves the issue and also
suggest running a Detect and Repair on the program. If neither issues work
create a new .ost file by doing a search and renaming it to .ost1 or
something to ...formatting or moving a radar chart's axis labels
I am attempting to change the orientation of a radar chart's axis
labels. Its orientation seems locked in place immediately to the left
of the 360=B0 gridline. I would like the ability to display the axis
labels directly over the range rings and along other gridlines, such
as 180=B0 or 270=B0.
With other charts, the formatting option allows one to select "high",
"low", or "next to axis" to change the position of the axis. This
maneuver seems to have no affect whatsoever on a radar chart.
As a final resort, I suppose I could turn the axis labels off...Outlook 2003 very slow #2
Several people in my office including myself have upgraded to Office
2003 over the last several weeks. Many of us have begun experiencing
performance problems. For example, I will click on another message in
order to view it in the task pane, and then Outlook will sit there for
ages before it gets displayed. The larger the message (including
attachments), the worse the problem. However, even a message that is
small with only a 100KB attachment seems to take 20-30 seconds to
respond... this was never the case before. Also deleting a message
I checked the Exchange 2000 SP3 server th...Naming a chart object
When charts are created they are named "chart 1", "chart 2", and so on
I need to name a chart in order to update it from vba, but when
select the chart I cannot click in the name box? Help
Message posted from http://www.ExcelForum.com
To rename a chart, hold the shift key down and select the chart.
This selects the chart object instead of the chart area. You can
then rename as usual.
Thanks Ed, so simple when you know how.
Message posted from http://www.ExcelForum.com/
...Comparing 2 Lists
Lets say that I have a Sales Forecast list with Customer Name and Sale
Status columns. The number of registries in this list changes every da
(some new sales opportunities are created and some are deleted).
1) How can I create a report to compare two days in order to know whic
registries have been added and/or deleted?
2) If I want to know if a Sales Status have changed from one day t
another, what is the best way to do it?
inomata's Profile: http://www.excelforum.com/member.php?act...Business Portal 2.5 #3
Receive error: The Business Portal data in the database you selected is not
compatible with this version of the Business Portal. You must select a
different database before continuing
What version of Great Plains are you using?
Visit MBS Blog Central
"thebigo9" <email@example.com> wrote in message
> Receive error: The Business Portal data in the database you selected is
> compatible with this version of the Business Portal. Yo...Creating users with ADC / Exchange 5.5 #2
I installed the ADC on my DC and created all connection agreements.
Now I can go into ADUC and create new users, but I don't see a mailbox being
created for a user.
Should that happen? If so, how long should it take? I tried sending an email
to the user I created and the mailbox isn't found. Also, there are no
Exchange tabs for the users name.
...merged cells and creating charts
I have tried to create a chart with data that is in merged cells where I have
put in a formula to calculate the average of 4 cells in the row above. When I
create the chart, it recognizes all 4 of the merged cells. So the graph has 4
spaces for the data for each number I am trying to plot. I just got 2007
version and do not recall this problem at all in 2003 version
Merged cells are to be avoided at all costs.
They can be used for column heading but for little else.
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Troubled...Web Browser Control on MFC View will crash application when view is destroied after loading XML file
This is a multi-part message in MIME format.
Dynamically create an web browser control and put it on a view in a MDI =
application. Navigate the control to a XML file on the local machine, =
with style sheets in the same directory. Then, after closing the view, =
the application will crash in about 2 minutes. And it consistantly =
throws an exception at this line in wincore.cpp
// call original wndproc for default handling
lRes...Archive file size #2
Yesterday, I decided to split my archive file that is around 1.2gb size. So
I created a new archive file (old archive.pst), and archived archive.pst to
that. It all seemed to work, but the size of the original file is to all
intents and purposes the same! How can that be? I thought archiving MOVED
the files rather than copying them.
Can anyone tell me what is going on and how to reduce the size of my
original archive file?
You need to compact the PST file after removing items out of it. This is
done by right clicking on the top folder ("personal folders&q...Purchase Order Approvals #2
If you access an Approved Purchase Order and change ANYTHING in the window,
such as the Comments, the status of the Purchase Order switches back to
Unapproved. Only changes affecting the document Total should switch the
status back to Unapproved.
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...Excel spread sheet #2
Every time I open ANY excel document on this CP it displays each individual
cell as a page.......how do I change this setting? Moving each page break
takes too long abd does not alway work.
try this macro to remove them all at once:
"dlam25mmm" <firstname.lastname@example.org> schrieb im
> Every time I open ANY excel document on this CP it displays each
> cell as a page.......how d...