Thread: Excel Graph
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fay Fay is offline
external usenet poster
 
Posts: 8
Default Excel Graph

Hello,

Need help with a dynamic graph. I am using a defined names to automatically
update a chart range but I want the number of horizontal data points to be
fixed at say 10 data points. I want to truncate old data points and add the
newest each time a new entry is made.

Thanks