Hi everybody!
i would really appreciate how i can get from the chart called "this is what I have" to the chart "this is what I want".
The data in the chart "this is what I have" are filled out using the below macro:
With ActiveSheet
.ChartObjects("Chart_2").Chart.SetSourceData _
Source:=.Range("awarded"), _
PlotBy:=xlRows
.ChartObjects("Chart_2").Activate
End With
How do I add the comments and arrows to the correct places?
The range "awarded" varies according to what I choose in a dropbox, so the comments will vary as well. Is this difficult?
Just adding another row of data with some comments does not work.
Any response would be appreciated..thanks
Bookmarks