View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day Kelly O'Day is offline
external usenet poster
 
Posts: 103
Default How to select an axis that is covered by data points?

Michael Moser:

I recommend that you use the Chart menu, I find it a major time saver.

This post gives you info on how to set up the chart menu so that you can
access it when you want.

http://processtrends.com/pg_chart_tips.htm#Chart_Menu


Kelly

remove *'s for e-mail


"mattgoof2005" wrote in message
...
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