Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jcook1

    Renaming Values in a selected range.

    Hi there, i'm a bit of a beginner and am having issues with the language. I'm trying to make it so i can refer to the values in a selected range. eg Dim XValues As String Range(Selection, Selection.End(xlDown)).Select Xvalues = <The Values in the range> Any ideas?
  2. jcook1

    Copying Chart to different sheet and changing series.

    i've managed what i was trying to do now. thanks for your help.
  3. jcook1

    Copying Chart to different sheet and changing series.

    the thing is i have the title, xvalues and yvalues to change the "Sheet1" on for 8 different datasets on 12 or so different graphs. i'll get rsi if i keep having to do it manually. anyway, i'll crack on with it tomorrow and see how far i get. thanks for the help.
  4. jcook1

    Copying Chart to different sheet and changing series.

    Hmm... The thing is i have the same layout on all my sheets, so all i need to change in the chart is the name of the sheet in the series string. will it be easy to do that with a combo box?
  5. jcook1

    Copying Chart to different sheet and changing series.

    Hi, I'm having issues with developing a macro that will copy a chart from one sheet, on which there is data that the chart is plotting, to another where there is new data (same format as the first sheet. I want the macro to then change the title and the series info to that of the name of the...

Part and Inventory Search

Back
Top