How to extract subset of data from graph using vba??

I

iprosper

New Member
Joined
Nov 26, 2008
Messages
2
I have a series of data with a date and price which I plot in excel. I want to be able to click or double click on the graph on a subset of the displayed points and have the dates for the selected points transferred to another part of the spreadsheet so I can do some cycle analysis on this set of points.

Does anyone know how to do this.
I use excel 2007, but code for excel 2003 would be ok.

Thanks
John<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<!--~-|**|PrettyHtmlStart|**|-~-->
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You must log in or register to reply here.

Similar threads

E
  • Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
757
profray
P
H
  • Question
Extract String from PDF and Insert in Excel using VBA
Replies
2
Views
1K
jdellasala
J
L
  • Solved
Subset rows and columns of excel table using structured reference, extract data into another table
Replies
5
Views
5K
Fluff
Fluff
M
  • Locked
  • Question
Extracting Data from external sources using VBA
Replies
0
Views
181
msa722
M
A
  • Question
Extract data from three sheets from several excel files
Replies
2
Views
121
abuzahira
A

Forum statistics

Threads
1,195,669
Messages
6,011,061
Members
441,580
Latest member
BornholmerBjarne

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top