Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating XY-Plot
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating XY-Plot
If you look at "Source Data" you'll see that you've got your X axis data
series covering columns A to K, whereas it ought to be just column A. You can edit things manually, but the trick in getting the wizard to get it right in the first place is to leave the top left-hand cell blank. Delete the word Jahr from A4, and insert chart again, & it should be right. -- David Biddulph "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating XY-Plot
"Andy Pope" 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. Hi, Thank you! It works :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to make a box and whisker plot (box plot) in Excel. | Charts and Charting in Excel | |||
Creating a plot in Excel with SeriesCollection | Charts and Charting in Excel | |||
how do I create a box-plot (or whisker plot ) graph? | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
creating names for data shown on a scatter plot | Charts and Charting in Excel |