View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
doofy[_2_] doofy[_2_] is offline
external usenet poster
 
Posts: 7
Default trying to programmatically change chart data range with vb.net

My reader automatically drops me to the bottom.

This code worked for me:

'set data range
oSeries = ws.ChartObjects(1).chart.seriescollection(1)
'names
oSeries.XValues = ws.Range("b" & rowEnrolling, "b" &
rowCnt - 1)
'values
oSeries.Values = ws.Range("f" & rowEnrolling, "f" &
rowCnt - 1)




Jon Peltier wrote:
These forums have traditionally been top-posted, at least for the past 8-10
years.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"doofy" wrote in message
...
Jon Peltier wrote:
Post on top like everyone else does, so it's easier to follow the thread.

I believe this would be the only newsgroup where I was asked to top post.
Are you sure the net nanny inquisition knows what you're doing here? ;-)

I'll look into what you said about the longs.