Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Charting Problem


  • This topic is locked This topic is locked

#1
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
Hey

I have a prob

Im creating a graph thru vba and its not allowing me to change series value and name
its a 1004 error code
"Unable to change Series values": or something

How do i change or do it?

Plz any1 Help????
  • 0

Advertisements


#2
stu_design

stu_design

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 217 posts
found this out on my own

With ActiveChart.SeriesCollection.NewSeries
.Name = x
.Values = Worksheets(x).Range("a2")
End with

PS this is using vba
  • 0

#3
admin

admin

    Founder Geek

  • Administrator
  • 24,504 posts
Closed at users request.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP