chart range determined by cell values

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
 
T

Tushar Mehta

[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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart distorts secondary axis when the x-axis is logarithmic 5
Customised Axis Values 2
Odd chart type needed 2
Positioning x axis at bottom of chart with negative values 5
semi log graphs 3
Help with Bar-Line Chart..not aligned?? 1
Using the full width of an Excel chart with two Y-axes 2
time scale proportional using a column chart - not just for scatte 4

Top