excelhelp
Dec 19, 2008, 05:39 PM
Hi ,
Thank you for allowing me to even ask a question. I hope I can make this simple and clear as to not confuse you. I am currently building an excel file. I will have 2 graphs on a sheet. One of the graphs I need to link the Y axis minimum and maximum scale, (and major unit if possible) to cells within the worksheet.
Once I complete this I will copy this sheet to multiple worksheets. Each sheet will be a separate unit in which that data will vary and depending on the data each worksheet will calculate a y axis scale min/max number to link to the graph in just that worksheet.
My first problem is that I do not know how to do this and also even if I did know the code I don't know how the code would just link to the specific graph on that specific sheet as I move/copy making multiple sheets w/ different data which will make each worksheet’s y axis scale vary.
I believe that charts have an chart/object # but once I have a code which I hope you can help me with I worry as to how it will work as I copy one worksheet w/ the code that links the specific graph's y axis to the cells on the worksheet?
What code can I use and how can I make each graph y axis specific to only the cell scale min/max on just that worksheet?
Thank you for allowing me to even ask a question. I hope I can make this simple and clear as to not confuse you. I am currently building an excel file. I will have 2 graphs on a sheet. One of the graphs I need to link the Y axis minimum and maximum scale, (and major unit if possible) to cells within the worksheet.
Once I complete this I will copy this sheet to multiple worksheets. Each sheet will be a separate unit in which that data will vary and depending on the data each worksheet will calculate a y axis scale min/max number to link to the graph in just that worksheet.
My first problem is that I do not know how to do this and also even if I did know the code I don't know how the code would just link to the specific graph on that specific sheet as I move/copy making multiple sheets w/ different data which will make each worksheet’s y axis scale vary.
I believe that charts have an chart/object # but once I have a code which I hope you can help me with I worry as to how it will work as I copy one worksheet w/ the code that links the specific graph's y axis to the cells on the worksheet?
What code can I use and how can I make each graph y axis specific to only the cell scale min/max on just that worksheet?