View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default Scatter plot with two data series having common x-values

My apologies! It does display the correct x-values, or at least the correct
range of x-values. I was thrown off because the x-axis labels it displays
are integers whereas the x-values that I input were decimals. So I guess it
displays a range of integer x-axis labels that includes all the x-values that
I input.

This is an improvement over previous versions, I think.

"Gordon" wrote:

Ok, I give up. In Excel 2007, how do I plot two data series having common
x-values? When I go to Select Data Source and Add a series, I have to
specify both x-values and y-values. If I add a second data series with the
same x-values as the first, then the x-axis labels are just 0,1,2,..., not
the x-values I specified. I do get a scatter plot with two data series, but
the x-axis is not correctly labelled.

This was no problem in prior versions of Excel, but like everything else in
the "easier to use" Office 2007, it is much harder to figure out.