I need to create a chart that has two stacked columns(side by side) i
the same period - Is this possible? There would be four rows of data
two data points in each stack.
Message posted from http://www.ExcelForum.com
Start by having a look here:
There is loads of useful information and lots of sample charts - along with
tips and tricks.
"Gabriella T >" <<Gabriella.T.email@example.com> wrote in message
> I need to create a chart...Another VS 2005 question
Thank you for all the comments you gave me on the question on upgrading from
VS 6 to VS 2005. I downloaded VS 2005 Express and started playing....
However, an application created with VS 2005 (on a Vista machine) runs fine
on that machine, but does not run on another machine (happens to have XP).
An error message pops up about something wrong with the application
settings. Any ideas? I searched Google and it seems that this problem is
somewhat common, but I don't know what to do about it.
Could you list the error message? Perhaps a DLL is missing from the other
...Pivot table question #3
Thanks for any help.
I want to make a pivot table on 2 fields. The y-axis has the "birth year"
(ie 1990), and the x-axis has the "years of life" (ie 4). The inner data is
the number of people/records/etc alive born at that year, that many years in.
I would like the pivot table to sum the number of records (this pivot table
is based on a query which has the birth years and years of life) for each
year that they are alive.
Something like this:
The data would have a birth y...Pivot chart question #3
I am using Excel 2007. In previous versions, I've seen filter dropdown boxes
on top of the pivot chart. But I haven't been able to put the filter box on
the pivot chart with Excel 2007. Now they reside in the PivotChart Filter
Pane. Is there a way to have them in the chart area?
If that's not possible, is there another way to show the filtered
values/labels on the chart?
...PSTL licensing & processing question
We considering a few of the modifier tools in the Professional Services
Tools Library and I have some questions regarding how the tools operate.
We're in our first year implementation with GP10 ... and we're finding there
are a few inventory items we'd like to change now rather than "living with
it forever", so we we're looking at the Item Number Modifier.
One question I have concerns licensing ... do I understand this right? PSTL
tools are not part of the enhancements program, so when an upgrade is
released, if I need the new version of the tool I nee...e-learning question about globalization(culture)
Here is the question from e-learning about globalization: Which method
illustrates how to retirieve information for the current culture of the
application.(Choose all that apply)
1. Create a new instance of the CultureInfo class, and instansiate it with
no values specified in the constructor.
2. Use CurrentCulture property of the CurrentThread property of the Thread
3. Create a new instance of the CultureInfo class, and use an invariant
4. Create an instance of the CultureInfo class using a specific culture, and
check the CurrentCulture property.
...Please help. Question about querying a subform
I asked this yesterday and see all kinds of questions around me being
answered and suppose i just did not word this correctly.
I have a table of lab results. It is related to my patient table. It is a
one-to-many relationship. I have a date field, which is the date of last
labs. I am trying to build a query that will pull only the most previous lab
from each patient, with the criteria of it having been more than 6 months
ago. I do not want to pull lab dates from 10 months ago, if there is one
within the last 6 months. This is for a Dr and it is a priority that I get
it d...Quick question for David (since I saw he was online earlier)
Could you point me in the direction of the Microsoft Small Business
Accounting newsgroups please? I had them in my other newsreader, but
have since lost them in this one. And, I know they should be pretty
easy to find, but I'm having a "blind" moment.
Patrick Dickey <firstname.lastname@example.org>
Smile.. someone out there cares deeply for you.
I will see what I can find out for you.
David Musgrave [MSFT]
Senior Development Consultant
MBS Support - Asia Pacific
Micros...Back up question
I am trying to back on back office and Looks like I am not doing right way.
My pc where data sit name is REGISTERPC When I go to back office and try to
back up and It asking me USENAME; REGIDTERPC/GUEST AND PASSWORD. I tried
all the password didnt work. I tried SA password and My adminstrator
password. the otherthing when I turn on guest account on register pc then
I got massege Your local setting not allowing. My window furewall is off But
antivirus is on . WHat I am doing wrong ?
You can't use the RMS built-in backup routine to backup a database to a
workstation'...a condition question
I have two columns of data. I want to know the average GPA of only those
students at Carter Middle School. Help?
GPA(COL A) School (COL H)
3.3 Carter Middle School
2.3 Carter Middle School
4.0 Carter Middle School
School")*A1:A4)/SUMPRODUCT(--(B1:B4="Carter Middle School"))
"Penny" <Penny@discussions.microsoft.com> wrote in message
>I hav...bandwidth questions
Exchange 5.5 sp4 - we are attempting to move all users from a remote
exchange server (in Mass) to the corporate exchange server (in Fla). The
bandwidth between the 2 sites is 156K. I've put 8 people on my corporate
server and they are screaming about slowness. It takes 5 minutes to open
an attachment, they sporadically get disconnected, etc. Are there any
rules, regulations or white papers that describe the best optimization for
this type of scenario? I have approximately 150 users to move to the
corporate server, but I need to get this issue resolved first or my phone
will never s...CRM 4.0 Email Router Questions
Two questions for the experts regarding email tracking and how that
1. If I edit a CRM email in my outlook to have a new subject line,
will the tracking token still remain in the background and track the
email in CRM? Let's say someone replies to an email and the reply is
tracked. I then change the subject, send and they reply again.
2. I have a CRM email in my Outlook and forward it to my manager with
additional comments to keep them apprised of some progress, will the
forwarded email be tracked in CRM?
1) You don't say which version of CRM you are using. CRM 4 ...Question about Excel 2003
When I open a file by Excel 2003, many cells has the tiny triangle(like the
sign of a comment) insered in the upper left corner. I have no idea why they
appeared because they don't when opened by Excel 2000.
Please advise. Thanks in advance.
Jason, that is excel "helpful" error checking, have a look at tools options
error checking to see what it is checking for, and to turn it off :)
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 Ex...2 basic Excel questions for you pro's
I am a very new user of Excel so bear with my "green-ness";
1) I have been creating links throughout my 13 sheet workbook, now when I
attempt to finish making these links today, the actual formula (=SUM(A36)) is
populating into the cell and not my data????
2) I have a section that I want users to be able to only select 1, like
"choose only 1" in a survey. When you select 1 cell, your previous selection
Thanks in advance for the help~
First basic question:
If you enter a formula and it appears in both the formula bar and the cell,
odds are Excel thinks ...Newbie question #4
I have this XML
<?xml version="1.0" encoding="utf-8"?>
<PORMessage key="new" j:effectiveDate="2007-05-21"
=================== END =====
Then my C# code is:
XmlNamespaceManager nsmgr = new XmlNamespaceManager(xmlDoc.NameTable);
XmlNode porNode = xmlDoc.Se...Extender Question #2
It is possible to have the extender window pop-up only under specific
Specifically, I want extender value to be filled in when a specific
line item is entered, and let it be blank or disabled when another
value is entered.
I don't believe you can with the standard edition, which is what you buy
through Microsoft. You might be able to use VBA to control it. Alternatively,
you can check out the Extender Enterprise edition because it does have the
ability to add conditions. The website is http://www.eonesolutions.com.au.
Charles Allen, MVP
...OLE Object Data Type Question
Hi, a friend of mine supports a very simple Access 2000 database for keeping
tracks of his .JPG file. The database has a table with several field, and
one of them is of OLE Object data typy. He opens that table, rightclicks OLE
Object field, selects Insert Oject and creates a link to a .JPG file. After
finishing insertion the OLE Object field contains kind of "MSPicture3" or
"MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now after
insertion into the OLE Object field a link, it contains "...CRM Licensing Question
When I enter the license code during setup of CRM Small Business Edition, it
shows 75 users. Does that mean, 75 users are legally allowed to use the
software? I'm trying to figure out how 3.0 licensing differs in the area of
number of seats (I understand the 2 editions, etc.). In 1.2, we purchase
only 5 seats. So how does that translate into 3.0? Do we have 5 seats or
Presentations Direct - "Document Finishing Solutions"
75 Seats. In small business edition that is the maximum number of
users if you install CRM 3.0...Windows 2008 Foundation
We are considering installing some small servers in some of our remote
offices to do simple file serving tasks. I am curious to know if Windows
2008 Foundation Server can provide the following services (and if there are
some limitations to them, plese let me know):
File Replication (back to our corp hq for file backups)
Secondary Domain Controller functions (in case of network outage at corp hq)
"dean.carrefour" <email@example.com> wrote in message
> We are cons...Question on Storage Limit for Standard Server
I know Exchange Standard is limited to 16 GIG's. (for now, until SP2) But is
that Actual DB size, or size of the 4 files. Different people tell me
different things. And I am trying to get the actual word on that.
I just deleted 2 users from our system. In the exchange admin program
together they showed about 4 Gig's of emails. After I deleted them &
Purged - the db size did not go down. When we did an Offline Defrag, it
freed up 1.0 GIG.
Is there something I am missing? The 4 files are around 13.0GIG. I don't
want to have the server shutdown (again)
Just trying t...Where do my questions go?
The last 2 questions I have asked on this site under Windows XP General have
just disappeared. I can till see my previous questions but not the last 2.
Help point me in the right direction please?
> The last 2 questions I have asked on this site under Windows XP
> General have just disappeared. I can till see my previous questions
> but not the last 2. Help point me in the right direction please?
Unfortunately - the trouble could be anywhere.
You are using the Microsoft web interface for the Newsgroups to paste these
messages it seems:
We currently use Surfcontrol as our outer perimeter mail filter and I need
it to query the AD via LDAP to import mail addresses to stop Directory
Harvest Attacks. I have a rule in the firewall to allow the mailfilter to
talk to exchange on port 389 but it fails and I believe I know why, even a
Am I right in saying that even though my mailfilter is talking to my Exhange
2003 box, the Exchange server is not listening on 389 for incoming
connections as it is only a member server?
For sure you should connect to a AD Domain Controller... User info is in AD.
Regards...Another curvy question....
I've now discovered that I can get some cort of curvy linear arrows by using
the Autoshape connectors, and this wouldn't be a problem apart from the fact
that the curved connecting arrows default to an 'S' shaped curve, whereas I
only want a simple arc. By manipulating the yellow adjustment handle I still
don't seem to be able to get a proper arc shape - it just moves the unwanted
bend in the curve.
The basic shapes in Autoshapes has a curved line. It is a simple arc.
I have a method of using text (WordArt) along a curved line. It ...Bulk Import Question
I'm trying to import Leads with Bulk Import Wizard. Everything seems
fine except that I can't pick the Target Field, it's greyed out. Is
this because the header record contains exact field names? It looks
like it is going to map to the wrong fields.
The options that are grayed out are required fields set within your form.
Are they on theleft hand column at the top of the list?
Microsoft Small Business Specialist
> I'm trying to import Leads with Bulk Import Wizard. Everything seems
> fine except that I can't pick t...Pivot Table for survey data w/ questions as Rows & poss answrs as
I'm trying to use a Pivot Table to present some survey results, and
could use a point in the right direction.
- The first question is "what department do you work for?"
- The rest of the questions all have the same possible answers
(agree, strongly, disagree, strongly disagree).
- The questions are the column headings in the source data set.
In the Pivot Table, I'm looking to:
- have the rows be the individual questions (col headings from data set)
- have the columns be the four possible answer (col data from data...