PDA

View Full Version : Solved: charts



chungtinhlak
02-25-2009, 12:31 PM
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.

xld
02-25-2009, 01:03 PM
Select the chart
Right click and select Chart Options
Select the Axes tab, change Category (x) axis from Automatic to choose Category

chungtinhlak
02-26-2009, 07:22 AM
works again. Thanks XLD