scatter chart x axis doesn't display correct values

**sthegreatone** · 03-30-2012, 10:30 AM

Hi,

I have a problem creating a scatter chart. The chart thinks that the x values are points on the graph even though I have put them in the X axis in the "Select Data" option.

Any help would be greatly appreciated! I have to do another 5 of these graphs so an explanation would be really helpful. Thanks in advance.

**Andy Pope** · 03-30-2012, 10:52 AM

Your x axis values encompasses 2 columns. Therefore the x values are simply categorical points 1 to 18

Alter formula from,

=SERIES("50% Brick (10% Lime)",'D28 50% 10%'!$G$19:$H$36,'D28 50% 10%'!$E$19:$E$36,1)

to
=SERIES("50% Brick (10% Lime)",'D28 50% 10%'!$G$19:$G$36,'D28 50% 10%'!$E$19:$E$36,1)