Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Data
I have data in a chart. I want to set up a macro to perform calculations on
this data, but I want to be able to select the "starting point" - which will not necessarily correspond to the first data point. Is there a way to allow a user to manipulate a "line" on the graph so that where they position that line (along the x-axis) will correspond to the starting position to perform calculations on the data? Any other suggestions? Thanks Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Data
Plot another series on the chart as a line, using two datapoints with
the same x-values and different y-values (use min y & max y). Set the series x-values to a cell and link a scrollbar on the sheet to the cell. Set the min and max of the scrollbar to the min/max of your x-axis data. The user can move the scroll bar to position the line on the chart. Tim. "Frank@shell" wrote in message ... I have data in a chart. I want to set up a macro to perform calculations on this data, but I want to be able to select the "starting point" - which will not necessarily correspond to the first data point. Is there a way to allow a user to manipulate a "line" on the graph so that where they position that line (along the x-axis) will correspond to the starting position to perform calculations on the data? Any other suggestions? Thanks Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel |