Scatterplot : X-axis Mod

**Pierre.Felx** · 12-10-2009, 11:51 AM

Hi everyone,

I'm trying to modify my x-axis so that it only displays the four values I have in my dataset (7221, 7222, 7223, 7224). While I can do this easily enough I don't want to have the values for 7221 on the y-axis, I want them where they are now in the graphic (See attachment). (In essence I just want to remove 7220 and 7225 from the graph without changing anything else)

**teylyn** · 12-10-2009, 06:38 PM

Hi,

can you possibly upload a workbook with the data and the chart? It will be easier to try out solutions.

BTW, I'll move this to the charting forum

**Andy Pope** · 12-11-2009, 08:23 AM

Use a custom number format on the x axis.
[White][<7221]General;[White][>7224]General;General

Format font to be transparent

**Pierre.Felx** · 12-11-2009, 09:57 AM

Thank you so much. This worked perfectly. I was having a little problem at first with my entire axis values disappearing until I realized that there were two "general"s in the custom statement instead of one.