View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bruce Bruce is offline
external usenet poster
 
Posts: 138
Default Scatter chart not plotting correct range

Have setup a scatter Chart but the x-axis is plotting the element position
rather than my x variable. The y variable is correct.

eg. A2:A20 contains var1. B2:B20 contains var2. Var1 plots correctly on
y-axis. Var2 does not plot at all, instead plots the element position i.e.
1-19.

Var1 and Var2 are assigned as 1 series with correet Y and X ranges
respectively.

Am i making sense? Anyone know what the problem is here?

Bruce