chart range determined by cell values

  • Thread starter Thread starter Rick Flaherty
  • Start date Start date
R

Rick Flaherty

I want to plot a semilog chart (x-axis is linear, y-axis
is logarithmic0. Iwould like to set the rangeto be set by
the data in the spreadshhet cells, i.e. the x-axis data
could be years from 1995 to 2005 on one occasion and 1997
to 2007 on another.
Can this be done?
Thanks,
RickF
 
[This followup was posted to microsoft.public.excel.charting with an
email copy to Rick Flaherty.
Please use the newsgroup for further discussion.]

By hand, double-click the x-axis, then in the resulting dialog box, the
Scale tab. Adjust the min. and max. values as desired.

To link these values to worksheet cells, you have to use a programmatic
solution. A free add-in that does this is the 'AutoChart Manager'
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