View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default creating XY-Plot

Hi,

Your xvalues range includes columns A thru L.
Move the cell A4 to A3 and select the range A4:O130 and use the chart wizard
to create you xy-scatter.
This time it should pick up the 14 stations.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Butterbrot" wrote in message
...
Hallo,

I have Problems making an XY-Plot of the Data I have linked.
There are Temperatures from some Weatherstations in the USA,
but if I mark the Cells with the Data, the Diagram shows
only 4 Stations. The last 4 from the list.

The X-Axis should be the Year and the Y-Axis should be
the Temperature in Celsius.

Can anybody help me what I have to do, that ALL Stations
occur in the Diagram?

http://home.arcor.de/maqqusz/temperatures.USA.xls

Yours
Markus