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 |
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 |