Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-22-2012, 11:34 AM
omahadivision omahadivision is offline Way to select a range using the mouse on a chart? Windows 7 32bit Way to select a range using the mouse on a chart? Office 2007
Novice
Way to select a range using the mouse on a chart?
 
Join Date: Oct 2012
Posts: 28
omahadivision is on a distinguished road
Default

Sorry for not being more specific. My goal is to select the range directly from the chart as opposed to the datapoints. I have written a module that detects the minimum in any range but I want the range to be determined by clicking on or dragging a rectangle on the actual chart. For instance, in the attached graph, I would want to figure out the minimum peak around 1400 wavenumbers by selecting the range around the peak. I have it set up so that a user can type in a range and it will calculate the minimum, but it would be cooler if they could just click on the chart.

Thanks!

Test.png
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making VBA select chart and then export as picture omahadivision Excel Programming 2 10-28-2012 07:53 PM
Way to select a range using the mouse on a chart? Mouse Over Animation dslocum PowerPoint 4 03-23-2012 09:20 AM
Can't select or edit chart data itguy PowerPoint 2 09-19-2010 10:13 AM
Converting manual chart to bar chart? aligahk06 Excel 0 07-03-2010 12:23 PM
Way to select a range using the mouse on a chart? Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft