Changing x-axis scale

G

Guest

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

Similar Threads

Formatting 'X' Axis -- 2 fundamental differences 7
Horizontal axis to the bottom 1
X-Axis Scale Options Missing 4
Gridlines & Tick marks 1
move y-axis to the left of x-axis "0" 2
X-axis in 2007 4
Logarithmic Scale for the X-Axis 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1

Top