Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Charting Question
I'm attempting to set up a dynamic chart. So far, I've defined a name for
cells B33:M33 (using the following offset equation). =OFFSET(Sheet1!$B$33,0,0,1,COUNTA(Sheet1!$33:$33)-1) I'd like to be able to add more columns after M and the chart will automatically pick it up. We have a graph that currently includes B33:M33 as the X axis values for a line chart. How do I change the information in the chart to include the determined dynamic range for X? Thanks in advance, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Charting | Excel Discussion (Misc queries) | |||
Dynamic Function Reference Question | Excel Discussion (Misc queries) | |||
a question regarding dynamic ranges and charts | Charts and Charting in Excel | |||
excel dynamic charting | Excel Discussion (Misc queries) | |||
Dynamic charting problems (events) | Charts and Charting in Excel |