View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
ers
 
Posts: n/a
Default 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