Thread: Expanding a chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta[_3_] Tushar Mehta[_3_] is offline
external usenet poster
  
Posts: 37
Default Expanding a chart
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

In article ,
says...
I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave the
right side of the chart empty.

Reply With QuoteReply With Quote