Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grpahical selection of points on Excel charts
HowTo,
You can't do that automatically, not through a macro. HTH, Bernie MS Excel MVP "HowTo" wrote in message ... I have a scatter plot in one of my excel workbooks, based on data in one of it's sheets. I would like to be able to "select" a set of points on the scatter chart (maybe by drawing a box around them). I would then like to automatically select the corresponding series/values in the spreadsheet containing the data for the scatter plot. How can I accomplish this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grpahical selection of points on Excel charts
Hi, Can I do it with some VB/C++ programming? Specifically, does the chart object allow more granular control on selection of points? Thanks "Bernie Deitrick" wrote: HowTo, You can't do that automatically, not through a macro. HTH, Bernie MS Excel MVP "HowTo" wrote in message ... I have a scatter plot in one of my excel workbooks, based on data in one of it's sheets. I would like to be able to "select" a set of points on the scatter chart (maybe by drawing a box around them). I would then like to automatically select the corresponding series/values in the spreadsheet containing the data for the scatter plot. How can I accomplish this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grpahical selection of points on Excel charts
HowTo,
I won't say "No" but I will say "It won't be easy, and it's beyond my skill, and it's not native to Excel." HTH, Bernie MS Excel MVP \"HowTo" wrote in message ... Hi, Can I do it with some VB/C++ programming? Specifically, does the chart object allow more granular control on selection of points? Thanks "Bernie Deitrick" wrote: HowTo, You can't do that automatically, not through a macro. HTH, Bernie MS Excel MVP "HowTo" wrote in message ... I have a scatter plot in one of my excel workbooks, based on data in one of it's sheets. I would like to be able to "select" a set of points on the scatter chart (maybe by drawing a box around them). I would then like to automatically select the corresponding series/values in the spreadsheet containing the data for the scatter plot. How can I accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Balance Points in Excel Charts | Charts and Charting in Excel | |||
XY Charts - not plotting zero or #N/A Points | Charts and Charting in Excel | |||
Line charts with missing data points in Excel 2007 | Charts and Charting in Excel | |||
Data Points in Excel Charts | Excel Discussion (Misc queries) | |||
Excel Charts - Time line for random points on X axis | Excel Worksheet Functions |