Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Map Point Plug-in for Excel 2007 | Excel Discussion (Misc queries) | |||
excel chart showing movable graph at what point we make a profit | Charts and Charting in Excel | |||
how do i export a graph from excel to power point? | Charts and Charting in Excel | |||
How do I point out a specific date on a line graph in Excel? | Charts and Charting in Excel | |||
Excel should let you graph every n-th data point in a column | Charts and Charting in Excel |