xy chart --> x and y axes scales min and max

[Brad]

I use Tushar Mehta's Automatic Chart Limits add-in for primary and secondary
values for many of my charts and I wonder if someone can point me to any
similar existing code/add-ins to link the min and max values for the Y axis,
and the min and max values for the X axis to values calculated in four
cells. My thanks in advance for any direction here. Brad

 

[Tushar Mehta]

I use Tushar Mehta's Automatic Chart Limits add-in for primary and secondary
values for many of my charts and I wonder if someone can point me to any
similar existing code/add-ins to link the min and max values for the Y axis,
and the min and max values for the X axis to values calculated in four
cells. My thanks in advance for any direction here. Brad

The add-in lets you set the min/max values for the x axis *if* the x
axis supports them. Currently, the only kind of chart that does is a
XY Scatter chart or a chart with the x-axis type set to 'Time scale'
rather than 'Category'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions