Greenbriars
Member
Although I am a competent Excel user, my knowledge of VBA is minimal. I wonder if someone can help me with a problem.
I have a workbook with 3 sheets.
1. Control
2. Data Input
3. Chart (it just happens to be of weight and some other data)
I use the control sheet to enter fixed data to be used in the chart. Titles, height, target BMI and some other stuff which get passed either to the data input sheet or to the chart itself.
The data input sheet is simply a table which records dates and weight and potentially comments. The table is also fed by the control sheet to record target BMI and to take the potential comments and add data so that the comment, date, weight and BMI can be displayed on the chart as a label.
The chart is self explanatory (I think). It is on a Chart Sheet, rather than being an embedded object on a worksheet.
What I want to achieve is to calculate a Y axis max and min in the control sheet, based on data in the data input sheet and use the max and min to scale the Y axis. I have no problem getting the correct max and min to appropriate cells in the control sheet.
I can use VBA to change the scale if the max and min data are on a worksheet with an embedded chart, but I have no idea how to change the scale based on data in another sheet.
Can somebody help me please?
Many thanks.
I have a workbook with 3 sheets.
1. Control
2. Data Input
3. Chart (it just happens to be of weight and some other data)
I use the control sheet to enter fixed data to be used in the chart. Titles, height, target BMI and some other stuff which get passed either to the data input sheet or to the chart itself.
The data input sheet is simply a table which records dates and weight and potentially comments. The table is also fed by the control sheet to record target BMI and to take the potential comments and add data so that the comment, date, weight and BMI can be displayed on the chart as a label.
The chart is self explanatory (I think). It is on a Chart Sheet, rather than being an embedded object on a worksheet.
What I want to achieve is to calculate a Y axis max and min in the control sheet, based on data in the data input sheet and use the max and min to scale the Y axis. I have no problem getting the correct max and min to appropriate cells in the control sheet.
I can use VBA to change the scale if the max and min data are on a worksheet with an embedded chart, but I have no idea how to change the scale based on data in another sheet.
Can somebody help me please?
Many thanks.