| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving chart series range data
When you select an embeded scatter chart the x-data and y-data range is
automatically bordered (in the source data table) by Excel. You are able to alter the range included in the chart by sliding the hot-spot of the border to resize it. If it is possible I would like to retrieve the range (in A1 format) of the newly resized border. This is to be part of an interactive chart modifying procedure in VBA. Does anyone have an idea of how to capture the new range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT in named range for chart data series | Charts and Charting in Excel | |||
| How do I pass series data x-value range to a chart from a cell? | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Retrieving the SQL query of the external data range | Excel Programming | |||
| retrieving values between 2 defined limits in experimetal data series | Excel Discussion (Misc queries) | |||
Threaded Mode
