Microsoft Excel - horizontal (catagory) axis labels; EDIT Tab=Dimmed...how do I make it ACTIVE?

Asked By a Boswell INNISS on 20-Jun-12 09:25 AM
Earn up to 20 extra points for answering this tough question.
I have X-Y ... imported from a larger file.
A number of (initial) X vals. are unwanted.

How do I DEL. the unwanted vals?
Pichart Y. replied to a Boswell INNISS on 20-Jun-12 10:19 AM
Hi,

Don't understand your requirement. Could you please more detail with your sample file

pichart Y

[)ia6l0 iii replied to a Boswell INNISS on 20-Jun-12 12:21 PM
You seem to have two different Questions. 

a) The Edit tab being disabled
b) How to remove/trim down axis values?

For b) You can change the scale of the selected axis (horizontal axis), and set a different maximum and minimum values. Also note that you need to change the Major units in this case. Increase it to a higher value, and few points would go away.

For a) You might have to lower the security options I guess. 

Hope this helps.
a Boswell INNISS replied to a Boswell INNISS on 20-Jun-12 01:07 PM
Clked Bttm start point Scale, (chnge to 'Auto') ... BINGO everything now correct! (Unwanted data; already deleted.)