Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to select an axis that is covered by data points?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to select an axis that is covered by data points?
Kelly -
Minor point: That's actually the Chart Toolbar. The Chart menu is in the menu bar between Tools and Window when a chart is active. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Kelly O'Day" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to select an axis that is covered by data points?
Michael, you can select your dat series (or any other element in yr chart)
and then use the arrow keys to "walk through" your chart elements until you arrive at the one you want to edit/re-format. As long you hv not too many plotted series this shld work. HTH, Henk "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Charting Data Series vs. Data Points? | Charts and Charting in Excel |