Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removal of number label from x-axis
When an x-y chart is formatted so that the x-axis intersect the y-axis in the
middle, the first number on the x-axis appears on top of the y-axis. Is it possible to remove this first number label? |
#2
|
|||
|
|||
Mickey,
Yes, you can. You will need to set up a dummy X axis series to do so. Assume you start with the following data for your XY chart: x y 1 4 3 3 2 4 3 5 4 4 5 5 Now assume that you want the X axis to cross the Y axis at 3. Add a second series consisting of the following data points below. The purpose of this series is to act as a dummy X axis. x y 0 3 1 3 3 3 2 3 3 3 4 3 5 3 6 3 In the Format Data Series dialog box, make sure that the second series is set to automatic or custom €“ you want it to look like a line. Also in the Format Data Series dialog box, go to the Data Labels tab and check the X value option. You can now individually select the data label for zero on the second series and delete it. Next, delete the reference to the second series in the legend. Finally, delete the chart generated X axis labels by double-clicking on them. In the Format Axis dialog box, go to the Patterns tab and set the tick mark labels = None and the major tick mark type = None. -- Regards, John Mansfield http://www.pdbook.com "mickey huson" wrote: When an x-y chart is formatted so that the x-axis intersect the y-axis in the middle, the first number on the x-axis appears on top of the y-axis. Is it possible to remove this first number label? |
#3
|
|||
|
|||
Hi,
How about a custom number format on the x axis. [Black][0]General The value may need adjusting depending on your data values. Cheers Andy mickey huson wrote: When an x-y chart is formatted so that the x-axis intersect the y-axis in the middle, the first number on the x-axis appears on top of the y-axis. Is it possible to remove this first number label? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
if you want to hide all of the data labels double click on the axis select
patterns and select none for Tick mark lables. You can also select the tick mark labels to show high or low to get them out of the graph area. If you just don't want a number on top of the y axis. set your scale parameters such that one of the displayed numbers is not at 0 If none of these are what you want there are other more coomplicated ways to do format Apparent axis data (Not all of them are really axis data) "mickey huson" wrote: When an x-y chart is formatted so that the x-axis intersect the y-axis in the middle, the first number on the x-axis appears on top of the y-axis. Is it possible to remove this first number label? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Move x axis label | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |