Auto-Scale X-Axis of Graph

[Phil Newman]

Hi,

I've got a dynamically changing x-axis range of values. If you
choose
one option (option button) the x-range goes from 0-60, option two it
goes to 80-140, option 3 it goes from 160-200.


However, for those graphs on options 2 and 3, it always manages to
display the graph from 0, which I don't particularly like, as 3/4 of
the graph is wasted on white space.


Is there a way to properly auto-scale the x-axis to the limits (or
just outside) of the x-axis data array?


I don't particularly want to record a macro for this...


Many thanks


Phil

 

[Bernard Liengme]

I think you will need VBA to do this. Jon gives you great instructions at
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html
best wishes

 

[Herbert Seidenberg]

Excel 2007 PivotTable
PivotChart auto-scales x-axis.
No code, no formula.
http://www.mediafire.com/file/thnjyck2jmt/03_25_09.xlsx

 

[Mike Middleton]

The Original Poster didn't specify the chart type, but it appears that OP
may be using an XY (Scatter) chart type (so that the x-axis is automatically
scaled from zero when using data in the 80-140 and 160-200 ranges). The
PivotChart feature cannot create an XY (Scatter) chart type. As far as I
know, VBA is the only solution to the OP's problem.

- Mike

http://www.MikeMiddleton.com

++++++++++++++++++++++++++++++++++++++++++++++++

Excel 2007 PivotTable
PivotChart auto-scales x-axis.
No code, no formula.
http://www.mediafire.com/file/thnjyck2jmt/03_25_09.xlsx

++++++++++++++++++++++++++++++++++++++++++++++++

Hi,

I've got a dynamically changing x-axis range of values. If you choose
one option (option button) the x-range goes from 0-60, option two it
goes to 80-140, option 3 it goes from 160-200.


However, for those graphs on options 2 and 3, it always manages to
display the graph from 0, which I don't particularly like, as 3/4 of
the graph is wasted on white space.


Is there a way to properly auto-scale the x-axis to the limits (or
just outside) of the x-axis data array?


I don't particularly want to record a macro for this...


Many thanks


Phil

 

[Phil Newman]

Hi,

yes, sorry I didn't mention that I was using an XY scatter graph. In
which case, by the sounds of it, VBA is the only option.

I'm also using office XP.

Many thanks for the help, I'll give VBA a try (although I'm a complete
novice!)

Phil