Functions and charts

[Waleed]

I have chart with Y-axis has numbers and X-axis has dates, if there is any
function which can read and return last number entered to Y-axis in the
chart. Can I get explaination for som of these symbols in Excel2007 if it is
possible:
#
!
$ used in chart as ='2008'!$B$5:$C$27
" "
' '
how they can be used in functions and charts
if there is any symbol to the logical OR and NOT as & for AND. how can these
symbols used in stead of using function OR and NOT,
ex NOT B5, OR B5
Thanks

 

[Bernard Liengme]

No such function
# is often used in the custom numeric formats (look in Help)
! is use to separate sheet_name from cell_reference
$ is used to make a reference absolute

We love helping with questions but we cannot give a complete Excel tutorial
in a newsgroup. It is clear that you are very new to Excel and would benefit
from reading an into book like Excel for Dummies
best wishes

 

[ShaneDevenshire]

Hi,

I have put some of the answers in-line below

If they help, please click the Yes button.
--
Thanks,
Shane Devenshire

I have chart with Y-axis has numbers and X-axis has dates, if there is any
function which can read and return last number entered to Y-axis in the
chart. Can I get explaination for som of these symbols in Excel2007 if it is
possible:

There is no spreadsheet function to return information from the chart. But
the chart gets it information from the spreadsheet so sometimes you can get
what you need from the spreadsheet using a function.

#

# sign usually means a column is too narrow for the numerical data that was
entered.

!

! is a separator between the sheet name and the cell address

$ used in chart as ='2008'!$B$5:$C$27

$ signs mean the reference is absolute.

" "

A pair of double quote usually means a space such as in =FIND(" ",A5) which
is looking at cell A5 and returning the numerical position of the space.

' '

Single quotes ususally surround references that include spaces or are
numeric within the file name or sheet name.

how they can be used in functions and charts

Most of the time we point and click in Excel in which case Excel takes care
of the detail for us, but if you manually enter references you need to keep
these symbols in mind.

if there is any symbol to the logical OR and NOT as & for AND. how can these
symbols used in stead of using function OR and NOT,

- There is no symbol for OR,
- In some cases you can use <> for NOT as in A5<>15
- & is not the symbol for AND in Excel. It is the concatenation operator
AND(A1=10,B1="Red) tests for both conditions
If A1 contained Shane and B1 Devenshire then =A1&" "&B1 entered in cell C1
would return Shane Devenshire. Note the use of " " to put a space between
the first and last name.