i am making a chart in which the cell range can change on-the-fly. for example, sometimes i may want to use cells B12:E13 and others i would use B12:G14 for the chart. what i want to know is if i can store that cell range in a separate cell and then somehow tell my chart to use that reference to select the range to plot?