Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Excel 2007: Lines not displaying on Scatter Plots

I have equipment that spits out system variables every minute for
weeks/months at a time. There are numerous gaps in the data when the system
is not "sampling", from minutes to days at a time, though I maintain
continuity of the Date/Time stamp that I use as the x-axis. So the data sets
I use are enormous, maximizing the capabilities of Excel (i.e. 30,000 points
per data series and typically no more than 6 data series per plot). The
chart data references multiple worksheets, so a Scatter Plot is the only
appropriate option.

I have recently installed Office 2007, though some programs of Office 2003
are still loaded on the system. When trying to plot Lines (w/ no Markers) on
Scatter Plots, the lines will display appropriately in the Legend but not in
the Chart Area. Then only way I can get data to display in the Chart Area is
by selecting Markers (w/ no Lines). This is not an appropriate work-around,
and I have NEVER had an issue creating plots like this in Excel 2003.

Any assistance would be greatly appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Excel 2007: Lines not displaying on Scatter Plots

What would probably help is changing the setting for how Excel deals with
blank cells. Right click on the chart, choose Select Data, and click the
Hidden and Empty Cells button on the bottom left corner of the dialog.
Choose the Connect Data Points with Lines option for how to show empty
cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"dyoung" wrote in message
...
I have equipment that spits out system variables every minute for
weeks/months at a time. There are numerous gaps in the data when the
system
is not "sampling", from minutes to days at a time, though I maintain
continuity of the Date/Time stamp that I use as the x-axis. So the data
sets
I use are enormous, maximizing the capabilities of Excel (i.e. 30,000
points
per data series and typically no more than 6 data series per plot). The
chart data references multiple worksheets, so a Scatter Plot is the only
appropriate option.

I have recently installed Office 2007, though some programs of Office 2003
are still loaded on the system. When trying to plot Lines (w/ no Markers)
on
Scatter Plots, the lines will display appropriately in the Legend but not
in
the Chart Area. Then only way I can get data to display in the Chart Area
is
by selecting Markers (w/ no Lines). This is not an appropriate
work-around,
and I have NEVER had an issue creating plots like this in Excel 2003.

Any assistance would be greatly appreciated.



Reply
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
Excel 2007 crashing with simple scatter plots with 8 k data points Boris Charts and Charting in Excel 7 February 25th 10 02:55 AM
Excel 2007: Lines not displaying on Scatter Plots dyoung Charts and Charting in Excel 0 April 23rd 09 11:21 PM
Excel 2007: Lines not displayed on Scatter Plot dyoung Charts and Charting in Excel 0 April 23rd 09 11:12 PM
Scatter plots in excel 2007 Rohini Gupta Charts and Charting in Excel 1 June 15th 08 09:18 PM
Excel gives me line plots - I want scatter plots Pangloss Charts and Charting in Excel 1 October 14th 05 02:15 PM


All times are GMT +1. The time now is 04:03 PM.

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

About Us

"It's about Microsoft Excel"