A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Line or Scatter Chart



 
 
Thread Tools Display Modes
  #1  
Old February 11th, 2006, 12:02 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 11th, 2006, 12:35 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 12th, 2006, 02:57 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 12th, 2006, 03:00 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 14th, 2006, 06:16 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 14th, 2006, 06:16 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01: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


All times are GMT +1. The time now is 03:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.