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!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Copy chart from one sheet to another
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...- Groubas
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Number of chart values depending on number of populated rows in listbx
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...- Groubas
- Thread
- Replies: 21
- Forum: VBA Visual Basic for Applications (Microsoft)
-
values from listbox, display chart in form
Im quite new at VBA but I have to solve this. I guess this is a two part question... 1 I want to create a scatter chart but my source data are in a listbox (-devided in two columns). What code should i write to set the listbox columns as source for the chart? 2 Is it possible to display the...- Groubas
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
