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
|
|||
|
|||
Excel Line or Scatter Chart
I have created a line chart with markers. The markers show, but the lines do
not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
#2
|
|||
|
|||
Excel Line or Scatter Chart
Millie -
Either a Line chart type or an XY (Scatter) chart type can be formatted to show any combbination of lines and markers. Click a data point to select the data series. Choose Format Selected Data Series, and click the Patterns tab. Choose the settings you desire. - Mike www.mikemiddleton.com "Millie" wrote in message ... I have created a line chart with markers. The markers show, but the lines do not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
#3
|
|||
|
|||
Excel Line or Scatter Chart
Are there blank cells in the data range? By default, Excel doesn't plot
them, leaving a gap in their place. To force Excel to draw a connecting line across this gap, select the chart, go to Options on the Tools menu, and on the Chart tab, where it says Treat Blank Cells As..., select Interpolate. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Millie" wrote in message ... I have created a line chart with markers. The markers show, but the lines do not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
#4
|
|||
|
|||
Excel Line or Scatter Chart
Pardon me if this appears twice, but Outlook Distress seems to have eaten
the first one. Are there gaps in the source data? By default Excel ignores these blanks, leaving a gap in the chart. You can tell Excel to draw a line across the gap. Select the chart, go to Options on the Tools menu, and on the Chart tab, where it asks how you want to deal with blank cells, choose Interpolate. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Millie" wrote in message ... I have created a line chart with markers. The markers show, but the lines do not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
#5
|
|||
|
|||
Excel Line or Scatter Chart
This worked. Thanks Jon!!!!
Millie "Jon Peltier" wrote: Are there blank cells in the data range? By default, Excel doesn't plot them, leaving a gap in their place. To force Excel to draw a connecting line across this gap, select the chart, go to Options on the Tools menu, and on the Chart tab, where it says Treat Blank Cells As..., select Interpolate. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Millie" wrote in message ... I have created a line chart with markers. The markers show, but the lines do not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
#6
|
|||
|
|||
Excel Line or Scatter Chart
This worked. Thanks!!!!
"Jon Peltier" wrote: Pardon me if this appears twice, but Outlook Distress seems to have eaten the first one. Are there gaps in the source data? By default Excel ignores these blanks, leaving a gap in the chart. You can tell Excel to draw a line across the gap. Select the chart, go to Options on the Tools menu, and on the Chart tab, where it asks how you want to deal with blank cells, choose Interpolate. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Millie" wrote in message ... I have created a line chart with markers. The markers show, but the lines do not. So I tried doing the chart as a Scatter chart with markers and lines, and the lines still don't show. What am I doing wrong? Help!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
How to create a line chart with two X-axes in Excel | JaVaughn | General Discussion | 2 | June 29th, 2005 04:52 PM |
I need to combine a bubble chart and a line graph (Excel 2003) | Rippbird | Charts and Charting | 1 | November 5th, 2004 12:23 AM |
Conditional Chartting | Os | Charts and Charting | 14 | October 16th, 2004 01:12 PM |
query an excel sheet and draw a line chart | Kanan | Worksheet Functions | 1 | April 18th, 2004 01:36 AM |