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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Excel: setSourceData make Border around...?

Status
Not open for further replies.

engine

Programmer
Nov 9, 2000
1
CH
Hallo Experts,

ActiveChart.SetSourceData Source:=Range("A1:A5,B1:B5")
PlotBy:=xlColumns

After the two lines above, Visual Basic automatically draws
a border around the datas in the Excel tables which appear in the chart. Every time when I click on the chart, i can see the related datas (border around)

My problem:
ActiveChart.SetSourceData Source:=Union(Range("A1:A2"), _ Range("A4:A6")), PlotBy:=xlColumns

After these two lines above, VB no longer draws a border around the data Range in the Excel table (because the Range is discontiguous)
why and can this problem be solved?

Thanks everybody in advance!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top