If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove Connnecting Lines from Line Chart?
Help! I want a line chart that only shows data points, not lines in between.
A scatter chart doesn't work correctly with the data. How do I remove the connecting lines from a line chart and just show the data points? Help is appreciated! |
#2
|
|||
|
|||
Remove Connnecting Lines from Line Chart?
"marti003" wrote: I am using Excel 2007. I want a line chart that only shows data points, not lines in between. A scatter chart doesn't work correctly with the data. How do I remove the connecting lines from a line chart and just show the data points? Help is appreciated! |
#3
|
|||
|
|||
Remove Connnecting Lines from Line Chart?
a) when you make the chart: select Insert | Line and from the gallery pick
the first one in the second row b) to modify existing chart: 1) right click chart; select Change Chart Type and select the Line chart that shows only data points 2) right click the data series in the chart; use Format Data Series and format to have no lines and markers to suit your need Have a look at his site http://office.microsoft.com/en-us/he...004991033.aspx Google with search term: excel chart tutorial 2007 best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "marti003" wrote in message ... "marti003" wrote: I am using Excel 2007. I want a line chart that only shows data points, not lines in between. A scatter chart doesn't work correctly with the data. How do I remove the connecting lines from a line chart and just show the data points? Help is appreciated! |
Thread Tools | |
Display Modes | |
|
|