| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Chart
I am plotting four series of data on one plot, with date as X axis. Only the
data points are plotted, no line connecting the data points. The formatting for each data series shows a line and symbol in the edit window fo each series. How can I get the lines to connect the data points? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Chart
Are you saying that you have 4 series, each of which contains only one
point, or do you have 4 series, each of which has multiple points which you can't get joined by lines? If the former, put all the points together in one series. -- David Biddulph "DEE" wrote in message ... I am plotting four series of data on one plot, with date as X axis. Only the data points are plotted, no line connecting the data points. The formatting for each data series shows a line and symbol in the edit window fo each series. How can I get the lines to connect the data points? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Chart
Are there gaps in the data? If so, go to Tools menu Options Chart tab,
and in the top section, choose the Interpolate option for dealing with gaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "DEE" wrote in message ... I am plotting four series of data on one plot, with date as X axis. Only the data points are plotted, no line connecting the data points. The formatting for each data series shows a line and symbol in the edit window fo each series. How can I get the lines to connect the data points? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Chart
That did the trick! Thanks very much.
"Jon Peltier" wrote: Are there gaps in the data? If so, go to Tools menu Options Chart tab, and in the top section, choose the Interpolate option for dealing with gaps. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "DEE" wrote in message ... I am plotting four series of data on one plot, with date as X axis. Only the data points are plotted, no line connecting the data points. The formatting for each data series shows a line and symbol in the edit window fo each series. How can I get the lines to connect the data points? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
| change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Linear Mode
