Thread
:
changing selections dynamically
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
changing selections dynamically
try this without the
Range("B4:J4").Select
ActiveChart.SetSourceData Source:=selection.address
--
Don Guillett
SalesAid Software
wrote in message
oups.com...
hello,
i am trying to set up a keyboard shortcut where i can select some
cells, hit the shortcut and a graph would be build based on the
selected data. so far i can do that but i can only graph data from the
recorded range when i start the macro B4:J4 - i want to be able to
graph from any dataset i select...
Sub graph()
' Keyboard Shortcut: Ctrl+Shift+G
'
Range("B4:J4").Select
Charts.Add
ActiveChart.ChartType = xlLine
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("B4:J4")
ActiveChart.Location Whe=xlLocationAsObject, Name:="Sheet1"
End Sub
thanks,
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett