Rescaling Chart Axes
Rescaling Chart Axes
(OP)
I need to set up charts which "read" results to use as the X axis and automatically draw the axis to a linear scale, regardless of the values. (Quattro does it but I can't find a route in Excel)
I am attaching a spreadsheet as a sample. Similarly how can I reset the linear axis so that it becomes logarithmic?
Should be simple I know but the only way I can make it work is by manipulating formulae to create evenly spaced values in the results.
David
I am attaching a spreadsheet as a sample. Similarly how can I reset the linear axis so that it becomes logarithmic?
Should be simple I know but the only way I can make it work is by manipulating formulae to create evenly spaced values in the results.
David





RE: Rescaling Chart Axes
To change either scale to logarithmic, right click just below the axis and select "format axis", then click the "logarithmic scale" box.
You will need to change the first chart point to something greater than zero.
The instructions above are for 2007/2010. The procedure may be slightly different for earlier versions.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Rescaling Chart Axes
=====================================
(2B)+(2B)' ?
RE: Rescaling Chart Axes
Not true. I have both. You can right click and change from line to scatter. Ditto for 2007
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize
RE: Rescaling Chart Axes
=====================================
(2B)+(2B)' ?
RE: Rescaling Chart Axes
David