|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
09-06-2008, 01:40 AM
|
|||
|
|||
|
How to Display a Moving Data Label
I have a 3 axis "live" graph that trends some production parameters. Data is collected via a DDE channel from Allen Bradley PLCs into Excel.
My question: Does anyone know of the way to display on the graph only the latest value on a trend line? My data updates once every 15 seconds. I need for the data label to show only the last updated value, while erasing or "hiding" all previous value labels. As you can deduce, if I select to display all data labels based on a value, my graph becomes unreadable due to the frequency of updates. All I really need is to show on screen the "current" (last) updated value for each trend line. If you need more clarification, please let me know. Last edited by Andy Pope; 10-11-2008 at 07:20 AM. 
|
|
#2
09-06-2008, 10:40 AM
|
||||
|
||||
|
When you say trendline do you mean a normal data series or an actual trendline?
You could use a second data series that only plots the last data point based on simple formula. http://www.andypope.info/charts/Labellast.htm Or it maybe possible to use a second series plotted as xy-scatter with a single xy value set, that references last point in data.
|
|
#3
09-07-2008, 12:27 AM
|
|||
|
|||
|
Thank you, Andy, for your reply. Yes, I do mean a data series. In my format data series I can checkbox "Value" and the value of each data entry is displayed. I need only the last value to display. Since this is an active trending graph, data is collected every 15 seconds. I need the previous label value to be erased as each new data series value is displayed.
I hope this clarifies things for your help. thanks.
|
|
#4
09-07-2008, 07:08 AM
|
||||
|
||||
|
The last label example will do what you want.
You will also need to use a dynamic named range in order to expand the length of the data series. There are plenty of examples of this on the forum.
|
|
#5
09-07-2008, 11:15 PM
|
|||
|
|||
|
I've taken a look at the last label models. I guess I am going to need a bit more detail/info from you on how to integrate the code into my existing worksheet and graph. I can post code if it would help. My data collection runs for 4 hours, and sample rate is every 15 secs. So, my table is A2:A960, C2:C960, and E2:E960 for each parameter I am graphing.
Your continued help is much appreciated.
|
|
#7
09-15-2008, 03:40 AM
|
|||
|
|||
|
That's slick. Perfect. Thank you, Andy for hanging in here. Best regards.
|
|
#8
10-11-2008, 04:31 AM
|
|||
|
|||
|
Issue Solved
Admin:
Please mark this thread as SOLVED. Thanks.
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DDE Macros and data formatting | JMann | Excel Programming | 12 | 03-28-2008 06:33 AM |
| Copy Paste Macro | xiao85yu | Excel Programming | 7 | 03-26-2008 03:42 PM |
| Moving Data Between Workseets | aces_up1504 | Excel Worksheet Functions | 1 | 12-06-2007 06:41 PM |
| Moving data into ONE Sheet from several others | jerryjaysr | Excel Programming | 8 | 12-05-2007 04:12 PM |
| Using formulas to display data on new sheet | shalie | Excel Worksheet Functions | 3 | 09-20-2007 08:57 PM |
Linear Mode
