| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plot missing data
Hi, using Excel 2007 how do I plot a line through points with no data? At the
moment there are gaps. Many thanks, Jonathan |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
Right click chart or Chart tools Design tab Select Data 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 _______ "Jonathan" wrote in message ... Hi, using Excel 2007 how do I plot a line through points with no data? At the moment there are gaps. Many thanks, Jonathan |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
"Jon Peltier" wrote:
Right click chart or Chart tools Design tab Select Data 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 'connect data points with line'? Many thanks Jonathan "Jonathan" wrote in message ... Hi, using Excel 2007 how do I plot a line through points with no data? At the moment there are gaps. Many thanks, Jonathan |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
Using a 3d chart by any chance?
Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Jonathan" wrote in message ... "Jon Peltier" wrote: Right click chart or Chart tools Design tab Select Data 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 'connect data points with line'? Many thanks Jonathan "Jonathan" wrote in message ... Hi, using Excel 2007 how do I plot a line through points with no data? At the moment there are gaps. Many thanks, Jonathan |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
"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 Select Data 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 'connect data points with line'? Many thanks Jonathan "Jonathan" wrote in message ... Hi, using Excel 2007 how do I plot a line through points with no data? At the moment there are gaps. Many thanks, Jonathan |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
1. Dunno.
2. I presume you have two X axes, but they both are located at the bottom of the chart. You should format the secondary Y axis, and on the scale tab (or whatever passes for the scale tab in 2007) cause the secondary X axis to cross at the Y axis maximum. Then you can format it to have a scale that matches the primary date axis. In 2003 you can plot an XY series properly on a line/column date axis, but this seems not to work in 2007. 3. Please post on top. This is the convention in these groups, and doing so makes the threads easier to follow (as opposed to some top posting and others bottom posting). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ 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 |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
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 |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plot missing data
I didn't think of combination charts. The Interpolate or Connect With Lines
option is not relevant to a column type. Since the setting is applied to the entire chart, if any series in the chart do not support this setting, it is not offered. If it is applied while it is still supported, it remains set. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
| How do i plot a data set that has one data point missing | Excel Discussion (Misc queries) | |||
| I am missing text in my y-axis title for my scatter plot | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel | |||
Linear Mode
