ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Graphs (https://www.excelbanter.com/excel-programming/332713-graphs.html)

owl527

Graphs
 

Hi, I have a bunch of data in excel, can I create a button so then it
will take data from the excel sheet and plot a graph? How do I go about
doing it? is there a tutorial somewhere? PLEASE HELP!
Thank you very much.


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=381853


mangesh_yadav[_357_]

Graphs
 

You may want to use the following event


Private Sub Chart_MouseMove(ByVal Button As Long, ByVal Shift As Long,
ByVal x As Long, ByVal Y As Long)


ActiveChart.GetChartElement x, Y, IDNum, a, b

....


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=381853



All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com