Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007: Lines not displayed on Scatter Plot
I work with equipment that spits out data every minute for weeks/months at a
time. There are numerous gaps in the data where I have blank cells (but maintain the continuity of the x-axis). My data sets are enormous, and the plots that I use to represent the data essentially maximize the capibilities of Excel (30,000 points per data series, and up to 6 data series per chart). These data series may reference data sets in different worksheets, so a Line Plot with a fixed x-axis is not appropriate. The Scatter Plot with lines (no markers) is the most appropriate selection for representing my data. When I select a Scatter Plot with Lines (w/ no Markers), the Lines will display in the legend, but not in the plot area. The data will not display unless Markers (w/ no Lines) is selected. This is not an appropriate work-around, and has NEVER been an issue in Excel 2003. Any thoughts would be greatly appreciated. - Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Scatter Plot Issue in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Issue | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Freak Out! | Charts and Charting in Excel | |||
Scatter plot with median and interquartile lines | Charts and Charting in Excel | |||
Excel Scatter Plot with connected by smooth lines | Charts and Charting in Excel |