Freeze chart location & size

  • Thread starter Thread starter dave_d
  • Start date Start date
D

dave_d

I do a lot of scientific charting of geologic data where
I present several different charts side-by-side on a
sheet. The data is usually some physical rock property
recorded at a particular depth. It is very important to
attempt to have these charts represent the same depth
interval across all of the charts. The problem is this:
Excel tends to resize the charts, at least vertically,
which tends to stretch and shrink the depth interval,
destroying the lateral correlations.

Does anybody know how to lock/anchor/freeze the charts so
that they don't change their dimensions. I can resize
them all with John Walkenbach's chart utility, but I need
to lock the locations on a sheet to maintain a lateral
continuity.

Any ideas ? Thanks for any help !
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to dave_d.
Please use the newsgroup for further discussion.]

Some version of XL had a bug that caused it to resize embedded charts
under certain circumstances. That was fixed in a subsequent support
release. You might want to search support.microsoft.com on the
subject.

Or, do you mean that it rescales the max/min values of the y-axis? If
so, check the 'AutoChart Manager' add-in available from my web site.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top