Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions and charts
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions and charts
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Waleed" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions and charts
Hi,
I have put some of the answers in-line below If they help, please click the Yes button. -- Thanks, Shane Devenshire "Waleed" wrote: 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. ex NOT B5, OR B5 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
data table - lines variables for DB functions, charts.. etc.. | Excel Discussion (Misc queries) |