+ Reply to Thread
Results 1 to 6 of 6

Excel Line or Scatter Chart

  1. #1
    Millie
    Guest

    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. #2
    Michael R Middleton
    Guest

    Re: 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" <Millie@discussions.microsoft.com> wrote in message
    news:74B4D21F-F202-40DB-9454-8F71AA31C183@microsoft.com...
    >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. #3
    Jon Peltier
    Guest

    Re: 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" <Millie@discussions.microsoft.com> wrote in message
    news:74B4D21F-F202-40DB-9454-8F71AA31C183@microsoft.com...
    >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. #4
    Jon Peltier
    Guest

    Re: 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" <Millie@discussions.microsoft.com> wrote in message
    news:74B4D21F-F202-40DB-9454-8F71AA31C183@microsoft.com...
    >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. #5
    Millie
    Guest

    Re: 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" <Millie@discussions.microsoft.com> wrote in message
    > news:74B4D21F-F202-40DB-9454-8F71AA31C183@microsoft.com...
    > >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. #6
    Millie
    Guest

    Re: 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" <Millie@discussions.microsoft.com> wrote in message
    > news:74B4D21F-F202-40DB-9454-8F71AA31C183@microsoft.com...
    > >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!!

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1