Customize labels on X-axis of charts

I have a chart that displays data for every 52 weeks at a time. The week number is displayed along the X-axis. As expected, all the 52 labels/week numbers do not show up on the X-axis since there isn't enough space which is fine. My problem is that I want to control which of the week numbers do show up and which do not.

Is there a way to do this?

Thanks much!

Find more posts tagged with

Comments

mwilliams

Hi smuks,

If you open the chart editor, open the format chart tab, go to the x-axis section, click on the label button at the bottom of the editor, and then you should be able to set an interval for the labels.