Excel 97 Chart

[danster]

Help!! The x-axis on a simple chart of two data columns keeps defaulting to categories 1 thru 5 instead of using the x-axis values. It does pick up and use the y-axis values. How can I get the chart to use a range of x-axis values on the horizontal axis instead of just the category numbers of 1 thru 5? Thanks.

 

[Mark W.]

How's your data organized? What's your chart's SERIES function look like?

 

[danster]

The data series are below. When the graph prints, the speed values are plotted with speed on the y-axis. But the x-axis only has the label "weight, lbs." and the numbers along the x-axis are 1, 2 3, 4, 5 instead of a range incorporating the actual weight values. Any suggestions? Thanks.
Weight, Lbs. 5 7 13 15 23
Speed, Ft/Sec 3.07 2.73 2.47 2.13 2.01