Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks, that helps.
Now, how can I reference this in a chart data range. If I edit the formula and press F9, I see the array. However, I'm trying to use this as Values in a Source Data range in a chart. In the chart, I'll edit the Values and select the cell with the array but only the first value appears in the chart. If I type in the array ={1;2;3;4} in the Values field, it displays fine. - John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please add an INTERPOLATE function. For vector or array data. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
need some help with an array function | Excel Discussion (Misc queries) | |||
Using AND function within an array formula | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions |