| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MAX value in column to use with text for title
I would like to find the maximum and minimum values (integers) in a column of
dynamic size. Then I will plug these values into the title of a chart, i.e. "WW17-26 Failure Pareto..." I can identify the dynamic range but can't get MAX() or LARGE() instructions to assign the largest value to a variable that I can use in the chart title in vba. I can find a solution by using =MAX("DynamicRange") inside a cell, but not sure how to get this into the title of a chart that is created through vba. Thanks for any help, rc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Title changes | Excel Discussion (Misc queries) | |||
| Find max value in a row and return column title | Excel Worksheet Functions | |||
| Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
| How to rename a column title in excel? | New Users to Excel | |||
| Sumif based on column A and title of another column | Excel Discussion (Misc queries) | |||
Threaded Mode
