View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default creating XY-Plot

check <chart<source data<series and check that the series are actually
selected properly in the X and Y series lists. I have had it take all the
last cell in a series and say that is the title.

"Butterbrot" wrote:

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