Hi,

Seems like you xaxis scale maybe category rather than date.
Right click chart and choose chart options.
On the axis tab make sure the xaxis is a date axis.
The the scale tab will allow you specify 7 days as the major unit.

Cheers
Andy

mah wrote:
I have a volume-open-hig-low-close stock chart. The left y-axis is volume,
the right y-axis is price and the x-axis is date. I need to "change the
scale of the x-axis so that the major unit occurs every 7 days." I've tried
different cpombinations of the Number of categoies between tick-mark labels
and Number of categories between tick marks and none seem to work.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info