Formatting X Axis


G

Guest

I am building a simple line chart that "charts" stock prices by date. For
example the data series of prices is cell c2:g2, then I am selecting the
x-axis labels which are in cells c7:g7. Problem is, more than 5 date labels
are displayed on my x-axis. For example, only 09/18/07, 09/21/07, 09/23/07,
09/25/07, 09/27/07 are the true x-axis labels that should correspond to my
data series, BUT, dates such as 09/20/07, 09/22/07, etc. are displayed as
x-axis labels. How do I only display the x axis labels that pertain to my
selected data series. I must not be scaling the x axis properly. Thanks if
you can help. Sony
 
Ad

Advertisements

A

Andy Pope

Hi,

The scale is being plotted as a date scale, due to the labels being
dates, instead of Categories which is what you want.
Right click chart and pick Chart Options. On the axes tab set the X axis
to be Category instead of Automatic.

Cheers
Andy
 
Ad

Advertisements

G

Guest

Andy - Thank you. Your advice was right on the mark. Much appreciated -
Tom, Now I can get on to the next step. Thanks again.
 

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