Excel charts with one standard grid and wide range of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overlay charts in 2007 2
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Axis Numbering Question 3
Time Scales on Horizontal Axis - Excel Charts 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Excel 2007 - How can I switch the data on vertical and horizontal 1
Excel 2007 limitations when plotting variable width column charts 1
vertical scale on both ends of bar chart 1

Back
Top