Hi,

It's seems you will also get the Connect option grayed out if you have a
combination chart.
If you set the option before changing the chart type of one of the series to
column then it appears to apply to the line series.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
On Jun 5, 1:45 pm, Jonathan
wrote:
"Andy Pope" wrote:
Using a 3d chart by any chance?

Cheers
Andy

Hi Andy, no simply a column of dates and another column of numbers.

Jonathan





Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Jonathan" wrote in message
...
"Jon Peltier" wrote:

Right click chart or Chart tools Design tab SelectData Hidden and
Empty
Cells (button in lower left of dialog).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

Hi Jon, thanks for you prompt response. I have found this dialog.
However
the 'Show empty cells as' only has the zero option available.

What's the trick to be able to select 'connectdatapointswithline'?

Many thanks
Jonathan

"Jonathan" wrote in message
...
Hi, using Excel2007how do I plot alinethroughpointswith nodata?
At
the
moment there are gaps.

Many thanks,
Jonathan- Hide quoted text -

- Show quoted text -


Same issue here...trying to plot DATE on X axis with BAR as Y1 and
SCATTER as Y2. There are 2 problems:

1. As with Jonathan, 'Connect data points with line' is not available
(only Gaps and Zero)
2. The data in SCATTER column does not line up correctly with the X
axis (DATE)...it is skewed in from the left (2004-01-30 data around
2004-07-30) and the right (2008-06-30 data around 2008-02-30).

Here is a view of the chart with all of the data:
http://i189.photobucket.com/albums/z...ampleChart.gif

Here is a small sample the data:
DATE(SOME DUP) BAR SCATTER
2004-01-30 19.23
2004-02-27 23.77
2004-03-31 30.78
2004-04-01 138441
2004-04-02 141657
2004-04-29 243856
2004-04-30 238183
2004-04-30 34.99
2004-05-03 256254
2004-05-04 210126


Cheers,
Dana