Changing x-axis scale

M

mah

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top