LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ake Ake is offline
external usenet poster
 
Posts: 18
Default Excel (2007) won't do a particular X-Y (Point) graph for me..

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Map Point Plug-in for Excel 2007 Tim Cesario Excel Discussion (Misc queries) 0 January 24th 08 04:58 PM
excel chart showing movable graph at what point we make a profit Mim Charts and Charting in Excel 0 October 22nd 07 05:48 AM
how do i export a graph from excel to power point? lisajensen21 Charts and Charting in Excel 2 August 15th 06 03:45 AM
How do I point out a specific date on a line graph in Excel? Keylay31 Charts and Charting in Excel 3 July 13th 06 08:41 AM
Excel should let you graph every n-th data point in a column warrenrob50 Charts and Charting in Excel 3 March 3rd 06 08:42 PM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"