Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to plot graph (newbie)
I have some data that need to plot a graph.
A column: X is the dates e.g. (2000-12-25) (already in date format) B column: Y is some numbers Can you tell me how to plot a graph in excel. I have tried but it gives me something very strange? (I can plot graphs with x and y are both numbers but if one of them is date, I have problem) Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to plot graph (newbie)
Might be easier for us to help if you were to tell us what has gone wrong,
rather more specifically than "something very strange" and "I have problem". You also haven't told us what sort of graph. I'll assume XY graph. The easiest way to help Excel to produuce your graph is to ensure that there is a label immediately above your Y data in column B, but no label above your X data in column A. Select the range including your data, the Y label, & the blank cell in the top left-hand corner. Insert/ Chart/ XY/ and go on through. -- David Biddulph "Lamb Chop" wrote in message ... I have some data that need to plot a graph. A column: X is the dates e.g. (2000-12-25) (already in date format) B column: Y is some numbers Can you tell me how to plot a graph in excel. I have tried but it gives me something very strange? (I can plot graphs with x and y are both numbers but if one of them is date, I have problem) Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to plot graph (newbie)
Make sure also that the dates are numerical, not merely text. Make the
column lots wider than the contents, select the column, and go to Format menu Selected Cells Alignment, and under Horizontal choose General. If the cells are right aligned then they are numerical. If they are not numerical, select the column, go to Data menu Text to Columns, and step through to where you can tell the wizard how the text is arranged (y-m-d it looks like), and when the text is converted to a column, it will be interpreted as numerical dates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Might be easier for us to help if you were to tell us what has gone wrong, rather more specifically than "something very strange" and "I have problem". You also haven't told us what sort of graph. I'll assume XY graph. The easiest way to help Excel to produuce your graph is to ensure that there is a label immediately above your Y data in column B, but no label above your X data in column A. Select the range including your data, the Y label, & the blank cell in the top left-hand corner. Insert/ Chart/ XY/ and go on through. -- David Biddulph "Lamb Chop" wrote in message ... I have some data that need to plot a graph. A column: X is the dates e.g. (2000-12-25) (already in date format) B column: Y is some numbers Can you tell me how to plot a graph in excel. I have tried but it gives me something very strange? (I can plot graphs with x and y are both numbers but if one of them is date, I have problem) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I plot multiple series on one graph? - test-graph.xls (0/1) | Charts and Charting in Excel | |||
How do I plot multiple series on one graph? - test-graph.xls (1/1) | Charts and Charting in Excel | |||
how do I plot a saw tooth graph | Charts and Charting in Excel | |||
Excel: plot graph | Charts and Charting in Excel | |||
how do I create a box-plot (or whisker plot ) graph? | Charts and Charting in Excel |