Recent content by Groubas

Ok thanks Skip, that looks good, but I wonder wouldnt I get a problem when I repeat the program and the second chart will be no 2 and so on... I mean since the code alignes ChartObject 1?

Heres the code that works: Sub plotChart() Dim chartEnd As Long chartEnd = Me.lstCoords.ListCount With ThisWorkbook.Sheets("TempData") .ChartObjects("Diagram 20").Chart.SeriesCollection(1).XValues = .Range(.Cells(1, 1), .Cells(chartEnd, 1)) .ChartObjects("Diagram...

Could anyone help me with this one? I want to copy a chart from one sheet to another. Now I've got this far on my own but its not woking like i want it to Private Sub cbtnPrint_Click() With ThisWorkbook .Sheets("TempData").ChartObjects("Diagram 20").Chart.ChartArea.Copy...

.... right, but if I showed the doctor all my values and told him about my problem them Im sure he would know whats wrong... that is if he would be a real doctor anyway I showed the code to others and they knew right away whats wrong with it so the problems solved.

Skip> The code that you posted didnt work at all and regarding your last question - If I knew I wouldn't post this thread, would I?

I have no idea what's in your listbox." the listbox contains the same values as the fist two columns in the worksheet and no I havent tried it yet

... but ill try your code as soon as i get to work tomorrow. anyway, thank you!

isnt that the same code that i posted? The listbox is still populated after i copy all the values to the worksheet so chartEnd = Me.lstCoords.ListCount should generate the same value as chartEnd = .Cells(.cells.rows.count, 1).end(xlup).row isn't that right?

its a xy-scatter chart (as you can se by the code). the user only enters the first two columns (x and y) the following columns are counted by the program. The program is more than 1500 rows so It would take too long to explain it all. The basic thing is that the values are now in the worksheet...

Im not sure what that has to do with this problem? could you explain?

ok, the user adds values to a listbox in the userform where the values are sorted like i want them, then by pressing a "plot"-button the values are copied to a worksheet and from there they are used to plot the chart. this is why I set chartEnd=listcount

I have the chart and program at work so I cant check that right now, but im quite sure that the ranges are defined... is that a problem?

Hi Im not quite sure what you mean (Im new at this). Its a user form - a multipage to be specific from the xl visual basic editor. the part when I copy the values from the listbox to a worksheet is already done in the program. The values were added by additem. I want the chart to be plotted...

Hello Ive tried to figure this out but I cant get this to work. The problem is that I want to plot a chart but the number of values varies depending on how many listbox rows that the user has populated. This is my code so far, but it doesnt work: Sub plotChart() Dim chartEnd As Long...

Thank You Zack That really helped me out G