Custom formatting chart axis

**ABSTRAKTUS** · 05-29-2010, 03:41 PM

Hi all!
Here I have a graph which contains 60 values (30 days a month, 2 shifts a day). All I want, is custom format. I want the scale show 1D 1N 2D 2N 3D 3N 4D 4N... Number means the day of the month, letter means whether is day shift or night shift. I`ve made a screenshot of this as my workbook weighs a ton. Any ideas?

Thanks in advance folks!

**ABSTRAKTUS** · 05-29-2010, 06:32 PM

All right... I guess its not easy, as nobody reply. Anyway, would it be possible to date every second step in the scale?

**ABSTRAKTUS** · 05-29-2010, 09:47 PM

I solved it.

**teylyn** · 05-30-2010, 01:13 AM

Abstraktus, please remember that not everybody is on-line and available at all times. Especially during the weekend, expecting an answer withing a few hours is a high stake.

Also, since this forum is about sharing solutions, maybe you want to post a few words about how you solved this.

I'd go for a dummy data series and the XY Chart Labeler to create labels for the dummy series, then remove the native axis labels.