Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel Macro Chart Mouse Event

Reply  
Thread Tools
babene's Avatar
Junior Member with 2 posts.
 
Join Date: Mar 2009
Experience: Intermediate
24-Mar-2009, 01:02 PM #1
Excel Macro Chart Mouse Event
I have a long Macro that runs and within the macro a graph is created (in the same sheet as the data) so now I have an "ActiveChart" that is an XY scatter scatter smooth no markers graph. I want to be able to click three (3) times on this graph and have those points (their x and y value) to be assigned to a particular cell, (we'll say we should put the X value of the first point that was clicked in "AA1" and its Y value in "AB1", then the second point would be in "AA2" and "AB2", followed by the third point going to "AA3" and "AB3". I have no idea how to even start this, but I just have an active chart that is made in the middle of the macro and I want to be able to click on that chart three times, record the data values, then have my macro finish running. Is there a way to do this!? Thanks!
Reply

Tags
chart, excel, macro, mouse click

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 11:14 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.