Thread: Excel charts with one standard grid and wide range of numbers

I have data for several charts, all of them need to on the same grid, so that
the vertical axis is the same size, scale and has the same set of numbers.
The data changes and the information on the horizontal axis changes.
How does this get set up?

In article <7DDBF17D-147B-4DB6-B143-17F6B416C345@microsoft.com>,
LeoCh@discussions.microsoft.com says...
> I have data for several charts, all of them need to on the same grid, so that
> the vertical axis is the same size, scale and has the same set of numbers.
> The data changes and the information on the horizontal axis changes.
> How does this get set up?
>
Let XL create its default chart. This will ensure all charts are the
same size. Then, double-click the y-axis and from the Scale tab set
the min. and max. values as desired.

--
Regards,

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