Hello All, I'm a very beginner for VBA, infact I learnt it only today. I'm having a problem while creating charts. What I want is to create a chart that will compare two distributions on a stack. e.g.
That is two say the two series are far apart. Far apart in the sense that if first is A1:A4 then the other is let's say C9:C12 but they should compare on a stack chart.
What I do is, I select the first series first and then select second making two selections thereby. Now I set the data range for each series. I make a range out of individual ith cells and then unite them into a new range using the union function. But the problem is that when I get the chart, its based only on the basis of first series and it entirely neglects the second series. When I check the source data, it only shows the value(not even the address) of the elements of first list. Can someone please guide.
' ' Keyboard Shortcut: Ctrl+t '
Dim SR, t1, t2, tmpRange As Range Set SR = Selection