| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change scales from reference cells value for a chart in a separate sheet
Thank you Jon,
It works, as is soupossed to. With .MinimumScale = ThisWorkbook.Sheets("XY").Range("$e$41").Value is ok. I found where was the mistake: I had protected before the worksheets (context object scenarios). I unprotect it being on XY spreadsheet where was the first chart ( but never thought I should go in Chart-sheet (second chart) and unprotect that one too separately!!!! Silly me. Next step: I had to find a way to protect the chart (series) but leave the scale free for change. Also to make the print to not stretch the chart and destroys square-grid (thank you for that too). I wish you a great weekend, Emil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
| how do i reference cells to create a chart? | Charts and Charting in Excel | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
Threaded Mode
