I am trying to set up a chart in which dollar values are on the Y-axis
and years are on the X-axis.  The data starts in 1993 and ends December
30, 2005.  Is there any way to include data labels only on the last data
point for each series?  When I select the data series to be ...

In a worksheet...
In Column A I Have Days of the Week.
In Column B I Have Dates of the Year respectively.
In Column C & D and E I have Data i.e Duty No.s  and Times

I have a problem where opening different excel files, opens in the same
window.  I don't mean showing each file in a column (I am using XP), but all
files using the same window, and no other files showing.  To go between each
file, I can use CTRL+TAB but would prefer to have ...

I was wondering how i would sort a column by the number of letters? for
example:
Mark
Larry

I know how to calculate the Average within a range of cells - however,
what I would like to do is calculate the average but for only those
cells that return a figure based on the results of another formula -
example:if you have 6 cells but only 3 cells return a value, I would

I'm looking at online and evening classes for excel.  Some of them mention
Excel XP is required software to take the course.  I have Excel 2003
installed on my home computer.  Is 2003 considered the same as XP?

I was entering dates of birth in a column as month/date/year. The year was
entered as two digits. 2/7/31 appeared in cell as 2/7/1931.
However, once I got below 1930 and entered a date as 2/1/29, it appeared in
the cell as 2/1/2029. Can you tell me what was happening?

i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a
spreadsheet. for some reason, when i go to window, the freeze pane option is
faded. how do i get it to work?

I would like to create a workbook where I can click on the cells in row one
(the column names) and the workbook will sort the whole row according to the
values in the column.  For example, I use Money 2002, and if I click on Num,
Date, or Payee, it will sort each row of data by ...

How can I create a total when using the Autofiler?

I got help with this in the past.  But I need more help.  What I need to
do is only copy cells in columns A-H if column 24 has an X in it.  This
is what I have so far.  Thanks in advance for your help.
Joe

Hi, I enter data in a cell, if the data is wrong, how can I make the
cursor to go back to the same cell, thank you.

I want to lookup a number it is most close zero in a numbers group.
and choice that number.
-10 -7 2 -10 -17 -7
for example. that 2 is most close 0 in group.

Is there a way to change the pivot source?
When I tried to refresh  a pivot, I get this: "cannot open pivot table
source file" and the file name.
Is there a way to point the pivot to a source file on a different path?

When I open my floppy disk of excel files there is no option to arrange by
name or alphabetical order.
How do you make a folder of excel files arrange by name/alphabetical order?
Thanks in advance.