Auto-Scale X-Axis of Graph

  • Thread starter Thread starter Phil Newman
  • Start date Start date
P

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
 
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

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

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

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

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
 
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
 
Back
Top