Charts - Declaring different X-axis values for different data sets

[thcanter]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to create a line chart with four different data sets. Trying to link each set with it's own x-values. When I select values for my data sets under "select data" it automatically forces those values on each set. Furthermore, I'd like to show the x-axis values on a linear scale (1-10) with data set points placed relative to the scale. Currently Excel sets the axis values to whatever values I associate with my data sets.

Any help is greatly appreciated!

Thanks,

Tim

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to create a line chart with four different data sets. Trying to
link each set with it's own x-values. When I select values for my data sets
under "select data" it automatically forces those values on each set.
Furthermore, I'd like to show the x-axis values on a linear scale (1-10) with
data set points placed relative to the scale. Currently Excel sets the axis
values to whatever values I associate with my data sets.

Any help is greatly appreciated!

Thanks,

Tim

You need to use a specific type of chart called XY-scatter.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 12.1.latest

 

[thcanter]

Thanks!