Thread: Chart with a defined named range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
scattered[_4_] scattered[_4_] is offline
external usenet poster
  
Posts: 18
Default Chart with a defined named range?
On Sep 12, 11:15*am, Matt S wrote:
I have a few ranges that are named within Excel. *I'd like to chart my
Beginning_Timer range against my Temp_Ramp range with a XY Scatter plot.

If I put * * ActiveChart.SeriesCollection(1).XValues = "=Beginning_Timer"
it gives me an error '91' Object variable or With Block variable not set.

Help?
<3 Matt

Maybe try ActiveChart.SeriesCollection(1).XValues =
Range("Beginning_Timer")

Reply With QuoteReply With Quote