M
michael sorens
I have found several articles that explain how to set up named ranges with a
formula such as this:
=OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)-1)
....then specifying the source data using the named ranges. Finally, applying
auto-filters to my data table will then automatically update my graph to show
the selected data.
The one additional piece I need is related to what I have selected via
auto-filters:
I have a collection of devices identified by a DeviceId. I want to pick one
DeviceId via the auto-filter drop-down to see that device's data in the
chart. I also want to label the chartwith the DeviceId I have selected. This
could be as simple as taking the DeviceId from the first displayed row in the
table. If it is not possible to put this into the chart as a label somehow, I
would settle for being able to put it in a cell (via formula) right next to
the chart.
formula such as this:
=OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)-1)
....then specifying the source data using the named ranges. Finally, applying
auto-filters to my data table will then automatically update my graph to show
the selected data.
The one additional piece I need is related to what I have selected via
auto-filters:
I have a collection of devices identified by a DeviceId. I want to pick one
DeviceId via the auto-filter drop-down to see that device's data in the
chart. I also want to label the chartwith the DeviceId I have selected. This
could be as simple as taking the DeviceId from the first displayed row in the
table. If it is not possible to put this into the chart as a label somehow, I
would settle for being able to put it in a cell (via formula) right next to
the chart.