Philosophaie
Active Member
- Joined
- Mar 5, 2010
- Messages
- 256
Sheets(1).ChartObjects(1).Chart.SeriesCollection(1).XValues = Sheets(1).Range("T2:T20")
Sheets(1).ChartObjects(1).Chart.SeriesCollection(1).Values = Sheets(1).Range("U2:U20")
Sheets(1).ChartObjects(1).Chart.SeriesCollection(1).Name = "Series Title" 'Sheets(1).Range("X1")
Sheets(1).ChartObjects(1).Chart.ChartTitle.Text = "Graph Title"
How do you at the beginning clear the previous Graph?
Sheets(1).ChartObject(1).???
Sheets(1).ChartObjects(1).Chart.SeriesCollection(1).Values = Sheets(1).Range("U2:U20")
Sheets(1).ChartObjects(1).Chart.SeriesCollection(1).Name = "Series Title" 'Sheets(1).Range("X1")
Sheets(1).ChartObjects(1).Chart.ChartTitle.Text = "Graph Title"
How do you at the beginning clear the previous Graph?
Sheets(1).ChartObject(1).???