having trouble creating chart to show monthly totals
I'm using office XP.
I keep a single spreadsheet were I record orders received.
Its a very simple sheet with one order per row.
In col B I place the date the order was received (in the format DD/MM/YY)
I'd like to make a chart (pie or column) which displays the total number of
orders per month so that I can see at a glance when were busy and quieter
I've tried using the wizard but all I ever get is a mess and not what I
expect to see at all.
I suspect I may need to separate my data by month? But is there a way for
Excel to work that out for itself from a sin...Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Help With the Customer Mailing Labels
For some reason the predefined Customer Mailing Labels report that comes
with the system does not work for me.
In Manager, I go to Utilities > Crystal Reports. I select my report and I
choose the sort field (or none) and choose a criterion (or none) and click
The application stops responding for a while and then I get the "Cannot Open
SQL Server" error. Same thing happens for all the other predefined Crystal
I have tried this on other machines as well, and got the same error.
The rest of the RMS apps run without a problem, so I know the SQL...Trendline and multiple data series
I have a scattergraph with four data series. Is there a way of inserting a
trendline which covers all four series?
Thanks in anticpation
Create a helper column that combines all the data series ...
> I have a scattergraph with four data series. Is there a way of inserting a
> trendline which covers all four series?
> Thanks in anticpation
...How do I create a dual axes column chart in Excel
Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
moment I add the secondary axis the bars are getting overlapped.
This example should help:
> Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
> moment I add the secondary axis the bars are getting overlapped.
...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Charts & Hidden Data
If I hide the row/columns containing the source data of a chart the
respective series disappears from the chart.
Is there any way to hide chart source data without affecting the chart?
In XL2003 (and before) with chart selected: Tools | Options |Chart and
uncheck the box "Plot visible cells only"
In XL 2007: Follow this path: click the chart; use Chart
Tools|Design|Selected Data; look for button
labelled "Hidden and Empty Cells"; complete dialog box as needed.
Bernard V Liengme
remove caps from ema...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...Bought a house! How to add into Money?
I just bought my first house a few weeks ago.
I have been using money for about a year now to track all my expenses,
budget, investments, etc. and have found it very useful. However, i
am wondering what is the best way to add a mortgage into money so i
can track what i have paid? Should i just do it as an normal expense
and maybe just break down the payment into subcategories (insurance,
taxes, mortgage) or is there an actual better way to do this?
I would suggst that you create an asset account for the house and a loan
account for the mortgage. Then create a payment in the bil...Help to add email account
I am unable to add my AOL email account to Outlook. Does anyone know the
addresses or how to do that?
We have some engineers that have fairly intesive graphs with tons of
data points on them. When we open the Excel 2003 graph with Excel 2007
and try to print the graph there is no data line or curve. Our axis'
and titles show up, even our 2 pt colored vertical lines appear. Now,
when we take all the data from this 2003 excel sheet and create a new
2007 sheet and create the graph from the data it prints fine. Also the
2003 graph will print frin ewhen opened from excel 2003. We've tried
the convert tool in 2007 when opening a 2003 workbook and still no
graph. We have a multit...How can I automatically enter repeating data from one table to ano
Hi I am a novice so if you can help please do. I have set up a database and
have a range of tables established for each of my categories and they seem to
be working well. How do I get the database to automatically fill in
repeating data (ie names) from one table to the next so I don't have to keep
retyping? Hope this makes sense.
Please help in simple English.
In a properly designed relational database system, you shouldn't have the
same data in multiple tables. You may want to read up on Database
Normalization. Jeff Conrad has some goo...Problems with backupexec 10d second storage group info. store restoration.
We have three mail box mailbox groups, we backup the information stores
using backup exec 10d
I have confirmed that mailbox permissions are the same for all three.
But the problems is that when I try to restore using the recovery
storage group I am successful using backup exec for the first storage
group but it does not work for the second or third.
I have dismounted the first storage group and deleted the files and
have added the second storage group to the recovery storage group but I
get the below error.
The error from backup exec is:
Final error: 0xe000ff00 - Unable to restore some Mi...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Add text to formula?
I have this formula kindly given to me in one of these Excel ngs:
=COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You Lost*")
The challenge is that any custom text I add to the cell formatting
doesn't show up in the cell. Would it be possible to add something
like this text below to the above (but also including line breaks)?:
Formula result of: =COUNTIF(E:E,"You Won!*")&":"&COUNTIF(E:E,"You
*********************...Editing XML data relation line
I am working on a program where I am retrieving data from an Access
database through one common dataset. I have already put the database
connection component on the form as well as the two data adapters.
Here is where I am having problems.
I double click on the .xsd file and then go to the schema menu and
select add|new relationship. My table names are Employee and Payroll.
Employee ID is a primary key in the Employee table and a foreign key
in the Payroll table. I need to define a DataRelation link with
Employee ID. The problem is that when the parent table is set to
Employee and the ch...Missing Data in Spreadsheet Contained in a Disk Image
Operating System: Mac OS X 10.6 (Snow Leopard)
I used Migration Assistant to copy all my applications and files to my new iMac i7. When I attempt to open a vital password protected Disk Image, the .dmg opens OK but the Excel file contained within doesn't have any data in it. Taking a copy of the .dmg from a backup disk results in the same thing. <br><br> What's really peculiar 'though is that if I right click the file before actually opening it, using Quick Look, it shows all the data is there. But the file still won't open the Ex...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...Trying to add or save a record.
I tried this awhile back and gave up. Trying again.
I made a form with two tables, customers & calls.
When I enter the phone number from the customers table that exists it
populates the form the way I want it and I can save the form or add a new
record and I think it is saving it in the calls table.
If I enter a phone that doesn't exist and try to exit or enter a new record,
I get the following.
The microsoft jet database engine cannot find a record in the table
'customer' with key matching field(s) 'Phone#'.
What I am trying to do is save the form even though ...Wanting to not add a blank element to the XML
I'm serializing a class and some of the elements end up with blank results.
This is fine. When I serialize the class the elements show up in the
resulting XML as something like
If it's blank how can I prevent this element from getting into the XML
completely . It is optional according to the schema but fails on validation
when it's in there in this form.
Could you post some code of your class and the serialization code, so that
we can try to make a repro on this issue?
"This posting is provided "AS I...Add multiple domains to spam deny list and real time sbl
What file can I open in Exchange 2003 to add a list of
domains I want to prevent from sending spam, so that I do
not have to add each one individualy. Also, how do you
set up Exchange 2003 to check the sbl.spamhaus.org real
time listing. They list the sites to block and say you
can connect to them for free. Can anyone please help?
...Export Access Data Project Queries to old Access .mdb file
I want to copy Access Data Project queries from a project into a new .mdb
file. What is the best way to do this?
In the new .mdb go to the menu bar, click file, Get
external data, and Import.
Select the orignal .mdb file and then the items.
>I want to copy Access Data Project queries from a
project into a new .mdb
>file. What is the best way to do this?
Any idea about the Data consolidation in excel . I have multiple excel
sheets and want to consolidate it without losing the data. other than
RDB data merge .
If those files have all the same schema, you can do it with a VBA macro using mso.
Le 2011-10-20 21:47, shivaprasad . shetty a �crit :
> Hi Team,
> Any idea about the Data consolidation in excel . I have multiple excel
> sheets and want to consolidate it without losing the data. other than
> RDB data merge .
> Thank you,
...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...sizing pie chart category data label
I would appreciate advice on re-sizing pie chart category data labels.
When I click on the label, I get a box around the text, just like
other microsoft applications, but when I click and drag on the points,
the text label box does not re-size...it stays the same size. Any
suggestions? Thank you.
I think it auto-adjusts to suit the font-size and text that you have
in there. Try right-clicking on the label, then you usually have
access to other features.
Hope this helps.
On Mar 9, 4:41 pm, susanh...@ou.edu wrote:
> I would appreciate advice on re-sizing pie chart category data labe...