View Single Post
  #2  
Old 08-19-2008, 04:48 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007
Posts: 2,634
Andy Pope is a jewel in the rough
Your data series includes the text in row 1. This has the effect of ignoring the values in column B as the X position. Instead the X position is a sequential value 1 to 15.

Adjust the series data bounds to exclude the first row and the chart will correct itself.
__________________
Cheers
Andy
www.andypope.info
Reply With Quote