| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scrollable crosshair on chart
Hi,
I am plotting x-y scatter data and would like to be able to create a scroll bar that would control a crosshair that is linked to the datapoints, so that by moving the slider I can move the crosshair throughout the data points shown on the chart. I want the crosshair to be linked to each datapoint. Is it possible to do this with one scroll bar, perhaps linked to row number, or some such data index variable? -- Thanks, Harry |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scrollable crosshair on chart
Would take too long to explain.
Look here http://people.stfx.ca/bliengme/exceltips/crosshairs.xls Come back (here or to me personally - email found on my website) for more into best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Harry C" wrote in message ... Hi, I am plotting x-y scatter data and would like to be able to create a scroll bar that would control a crosshair that is linked to the datapoints, so that by moving the slider I can move the crosshair throughout the data points shown on the chart. I want the crosshair to be linked to each datapoint. Is it possible to do this with one scroll bar, perhaps linked to row number, or some such data index variable? -- Thanks, Harry |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scrollable crosshair on chart
Bernard,
That solves my problem! Great stuff. Now, is it possible to display the crosshair lines to the axis limits? -- Thanks, Harry "Harry C" wrote: Hi, I am plotting x-y scatter data and would like to be able to create a scroll bar that would control a crosshair that is linked to the datapoints, so that by moving the slider I can move the crosshair throughout the data points shown on the chart. I want the crosshair to be linked to each datapoint. Is it possible to do this with one scroll bar, perhaps linked to row number, or some such data index variable? -- Thanks, Harry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name stays, everything else scrollable. | Excel Discussion (Misc queries) | |||
| I have a unwanted crosshair in the middle of my worksheet | New Users to Excel | |||
| How can I make the top row of my spreadsheet non-scrollable? | Excel Discussion (Misc queries) | |||
| Scrollable x-axis in excel | Charts and Charting in Excel | |||
| Print scrollable user form. | Excel Discussion (Misc queries) | |||
Linear Mode
