Date Range for X-Axis Labels


S

sony654

I want my line chart to plot to 9 dates selected from the worksheet. How do
I get the x-axis scale to match and display my dates? I am using the x-axis
labels option and it doesn't return the dates on the x-axis of my chart.
Thanks for your help. Tom
 
Ad

Advertisements

J

Jon Peltier

By default, Excel applies a time or date scale axis, which includes all of
the dates as if it were a continuous scale, with ticks and labels at regular
intervals. If you want only to show specific dates without regard to the
date (i.e., with data points equally spaced), change to a category type
axis. In 2003 and earlier, go to Chart menu > Chart Options > Axes tab, and
change Automatic to Category. In 2007 select the axis, right click and
choose Format Axis, then on the first pane you encounter, change from Date
Axis to Text Axis.

- Jon
 
Ad

Advertisements

S

sony654

Jon, Sorry for the late reply and rating. Your advice was right on and much
appreciated - Tom
 

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