View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
mattgoof2005 mattgoof2005 is offline
external usenet poster
 
Posts: 28
Default How to select an axis that is covered by data points?

You can right-click the numbers below the axis as well.

"Michael Moser" wrote:

In some chart I would like to adjust some parameters of the X-axis (esp.
the minimum and maximum, since the values choosen automatically are a
bit "uneven" and it would be nice to have a range of 0..20'000 and
tickmarks at 5'000, 10'000 etc, than an axis of 1..17495 and tickmarks
at other odd numbers.

But my charts has 20000 data points and many of those lie on or very
near the X-axis. So, how can I select the X-axis itself (in order to be
able to do a right-click and then select "Format Axis")? Whenever I try
to select the axis I only select the data series. And there seems no way
to adjust the axis' properties via the menu.

Michael