Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Slight twist on dynamic ranges
If I have a vertical list of Types, Dates & Weights, how can I chart
the dates vs. weights if the start and end cells are changing i.e. the range of a certain type may be A15 to B25 one time and A16 to B27 after new data is added. Manually changing the chart ranges whenever new data is added to the list is getting to be a pain in the butt. Thanks for any help or ideas! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Slight twist on dynamic ranges
Hi,
You need to also specify the number of rows to use in the offset formula. See here for details on dynamic ranges. http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html Cheers Andy jashburn13 wrote: If I have a vertical list of Types, Dates & Weights, how can I chart the dates vs. weights if the start and end cells are changing i.e. the range of a certain type may be A15 to B25 one time and A16 to B27 after new data is added. Manually changing the chart ranges whenever new data is added to the list is getting to be a pain in the butt. Thanks for any help or ideas! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple dynamic ranges in a Sumproduct | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
Indirect and dynamic ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |