hello, I have some charts, my x axis are dates generate by a formula that xld just helped me with. Somehow, the cells that contain the x-axis does not have the weekend dates on it. But on the chart, it doesn. Is there a way to remove it.
please see attached file.
Select the chart
Right click and select Chart Options
Select the Axes tab, change Category (x) axis from Automatic to choose Category
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
works again. Thanks XLD
Posting Permissions
Reply With Quote
