Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|