Changing x-axis scale
 

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.

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