Excel 97 Chart

danster · Feb 25th, 2002, 10:20 AM

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. · Feb 25th, 2002, 10:24 AM

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

danster · Feb 25th, 2002, 05:32 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 10:20 AM	#1
danster New Member Join Date: Feb 2002 Posts: 2	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.

Feb 25th, 2002, 10:24 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	How's your data organized? What's your chart's SERIES function look like?

Feb 25th, 2002, 05:32 PM	#3
danster New Member Join Date: Feb 2002 Posts: 2	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