View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ake Ake is offline
external usenet poster
 
Posts: 18
Default Excel (2007) won't do a particular X-Y (Point) graph for me..

Hi,

Well, Excel _does_ X-Y graphs, but not this one.
I have, in the columns A, B, G, and E from row 7 to 5175, sequential time,
data, and data (and dummy data) , respectively.
When I make an X-Y plot using the time column for the X-axis, it plots as
expected.
But when I plot column B versus column D, I get column B on the Y-axis, and
the (relative?) row number on the X-axis. (There are gaps in the data, but
any gaps plot alright in a smaller data sub set, even if they are not
matched).
My workaround consists of plotting B versus D and E, and then remove E ;-)
Somehow it seems Excel won't make a proper X-Y plot properly if just two
columns are given. (because of the large number of rows? and/or the gaps,
and/or because the E column had no gaps)

Can anybody explain?

Best regards / Ake