Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default dynamic charting and snipping cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"