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...Display SSN
We have reports (SSRS) and asp.net web pages that I would like to display
only the last 4 digits of SSN with leading X's. For example, 123-45-6789
would display as XXX-XX-6789. Is that possible? Thanks.
...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...Displaying an edited bitmap
I am currently working on a dialog application in which I want to
display a bitmap which I manipulate based on data in a file.
I can display the bitmap by putting the following code, copied from
CodeGuru, in the OnPaint function:
HBITMAP hBmp = (HBITMAP)::LoadImage(NULL, "filename.bmp",
IMAGE_BITMAP, 0, 0, LR_LOADFROMFILE/LR_CREATEDIBSECTION);
bmp.Attach(hBmp); // CBitmap bmp was declared as a member function in
the class view
CBitmap *pOldbmp = bmDC.SelectObject(&bmp);
...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
*********************...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...Summing specific texts
Hi, please help me, I need assistance:
I am trying to find the total number of times a specific word has bee
entered in a column. I tried using LEN and SUBSTITUE but it seems lik
that only works if it's a single letter?
Here's the details - some one much smarter than I am will surely hav
an answer for me?
Word is *Toffee *
(and is written in A1)
The field is *D1 to D600 *(a text formatted column containing singl
words in each cell)
-I have had some success with the LEN and SUBSTITUTE formula when usin
a single letter but I have had to write out the whole field a
D1&D2&D3&...how do i make the excel chart axis title boxes bigger?
The text is often truncated as though it were too long for the box. If I
reduce the font the titles are often too small to read. How do I "grow" the
boxes to accomodate longer strings?
Perhaps try Andy Pope's response to a similar past query:
GMT+8, 1� 22' N 103� 45' E
"Patrick98001" <Patrick98001@discussions.microsoft.com> wrote in message
> The text is often truncated as though it were too long for the box. If I
Excel allows 32,767 characters in a single cell but it only displays th
first 1,024. Is there a way around this? If so, please explain i
laymans terms. Thank you very much for any help you can provide
Message posted from http://www.ExcelForum.com
You can't break the 32k limit, but you can see more characters in the cell if
you pepper (a layman's term <bg>) your text with a bunch of alt-enters where you
want to see line breaks within the cell.
Hit and hold the alt and then hit enter at various spots.
> Excel allows 32,767 characters in a single cell but...Radar Charting problems, Can I change...
I have 2 queries relating to Radar charts in Excel (Office XP/2002).
Can I change the angle/start position of the first plotted point? I
always starts at 12 o'clock but I want it to start at 9 o'clock. I ca
re-order the data to achieve this effect but the data, to the viewer
is not in a logical sequence if I do that.
Then also, can I change the direction of the plotting from clockwise t
Thanks in advance.
Message posted from http://www.ExcelForum.com
You can't do these things (unless someone smarter than me knows how),
but you c...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...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...Texte arabe dans Word
> Ce message est au format MIME. Comme votre programme de lecture de courriers ne comprend pas
ce format, il se peut que tout ou une partie de ce message soit illisible.
J�utilise l��dition fran�aise de Word 2004 (version 11.3.8) sous le
syst�me d�exploitation Mac OS 10.4.11. Lorsque je colle du texte arabe dans
un document Word, depuis TextEdit par exemple, l�application quitte
inopin�ment. Si j��cris directement dans Word, les lettres ne sont pas
attach�es. Sauri...My Bar Chart Is Missing
I have inserted a bar chart and I have used one of PowerPoint's built in
templates. I saved the presentation and now when I open it up the chart
outline opens up, the Chart Tools contextual tabs open up, I can view the
data, but the slide does not show the bar chart?
Your help is greatly appreciated!!!!
...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 ...Chart Variables
I am using Excel 2003. I'm using "Option Explicit" to force variable
declaration. I want to tie the axes of a chart that I have named "MyChart"
to worksheet cells. I've been working with the following but continue to get
Dim Cht as ChartObject
Set Cht = Worksheets("Model").ChartObjects("MyChart").Chart
.MaximumScale = Sheets("Charts").Range("C7")
.MinimumScale = Sheets("Charts").Range("C9")
.MajorUnit = Sheets("Charts").Range("C...Listbox contains check box, small image icon and text
I would like to implement a list control in which every row contains check
box, small image icon and text. how can I do it? Are there any sample codes?
Nothing impossible, Nothing sure
This will be a good start:
"NianHawk" <NianHawk@hotmail.com.invalid> wrote in message
> I would like to implement a list control in which every row contains check
> box, small image icon and text. how can I do it? Are there any sample
Dont k...Rich Text / Plain Text. Error message
Every time I send an email, I get a window telling me that the email I am
sending is in Rich Text format ((HTML) and asking me whether I wish to
proceed by sendng in HTML, sending Plain Text or canceling.
This is regardless of whether I am sending a simple attachment (Excel file a
picture) even without any text.
I have also just deleted my old account and re-set it up again.
Please can you tell me how to avoid this message in the future?
Looking forward to your answer in anticipation.
Isn't there a "Don't show me this again" ...Design issue; and finding and displaying row on other workbook
1. An academic course is divided into two sections: lecture and
discussion. The lecture section contains all classes, but the
discussion classes do not. The discussion section is further divided
into three subsections, each containing multiple classes.
The need is to coordinate student attendance and grades for all
sections. Currently we have 1 lecture section workbook with all
student names, IDs, and other info; and 3 discussion section workbooks
with the same only for the relevant subsection. And then there is a
consolidation workbook where lecture and discussion are put together
and attend...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...Exporting email with atachment to text file
I would lke to have a backup of all my email in a pure text form. Many
years ago I used Netscape email, and the entire mail file was pur text;
attachments followed the message and were encoded in base64. I could
always retrieve my email (with a little effort) by cuting and pasting,
and using uuencode to retrieve the binary form of the attachment. Is
there any way to do this in Outlook?
I have recently encountered difficulties with different versions of
Outook at home and work, so would like to avoid problems like this in
the future by having a purely text email file.
<dtshedd@yah...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...Alphabetizing text
I am new to exel and have no clue as how to enter a formula or which one to
use. I want to put in a big directory with dept. names and their new
extensions. Then I want it alphabetized only. Any help would be appreciated
especialli in lame man terms.
It's easier if you have headers, then just select the whole range and do
data > sort and sort ascending by the dep names ( I assume)
"Barb" <Barb@discussions.microsoft.com> wrote in message
>I am new to exel and ha...