Editing labels of a secondary Xaxis

[Shay A]

Hi,
can anyone please help me with that? I wand the labels on the primary Xaxis to be shown on the secondary X axis so there won't labels on primary X axis. However, I do want the horizontal line at the value of "0" to stayat the same position.

Thanks!

@vletm

 

[vletm]

@Shay A
Please, check Your terms.
Try to make some kind of drawing to get idea of Your vision...
Did You try to ask to do something with 'Sheet3'?

 

[Shay A]

Hi,
All need to do now is to delete the labels "1" and "2" from the primary axis. I do need the line to appear on the chart thogh. (the line at "0" level.

TY

 

[vletm]

@Shay A
Deleting done.
The 2nd

 

[Shay A]

@Shay A
Deleting done.
The 2nd

wow! how did you do it?!
@vletm

 

[vletm]

@Shay A
... deleteing ... moved mouse over number, 'light right click' and delete
and
the 2nd part ... what did You wanted?

 

[Shay A]

but when I do what you said, Excel delets the axis too. Like I said, I want to keep the X axis.
@vletm

 

[vletm]

@Shay A
Next to Axis => None

 

[Shay A]

Thanks!!!