| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up a Chart in Excel with variable cell length?
On a result of a formula, the number of cells used can vary, how can I creat
a chart whose series length vary with the results? Can this be done in VBA? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set up a Chart in Excel with variable cell length?
Hi,
Can be done with named ranges. Here are some links including a page of further links. http://peltiertech.com/Excel/Charts/Dynamics.html http://tushar-mehta.com/excel/newsgr...rts/index.html http://peltiertech.com/Excel/Charts/...hartLinks.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Kev" wrote in message ... On a result of a formula, the number of cells used can vary, how can I creat a chart whose series length vary with the results? Can this be done in VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a Variable value length | Excel Worksheet Functions | |||
| Transpose a variable length list into Excel / Access Table | New Users to Excel | |||
| how do I do a variable length array based on the value in a cell | Excel Discussion (Misc queries) | |||
| Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
| Excel 2003: In a Macro,how to select a variable row length table | Excel Discussion (Misc queries) | |||
Linear Mode
