PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Why is my 3rd x axis values only showing the bullets & not line?

Reply

Why is my 3rd x axis values only showing the bullets & not line?

 
Thread Tools Rate Thread
Old 14-08-2007, 04:46 PM   #1
=?Utf-8?B?bWFyaWFu?=
Guest
 
Posts: n/a
Default Why is my 3rd x axis values only showing the bullets & not line?


I have 3 values for my x axis. With each value I have chosen the line graph.
My 3rd value only shows the bullets and not the line. I have tried changing
the color but that doesn't work. My first 2 lines are correct. Can't find
where I am doing something wrong
  Reply With Quote
Old 14-08-2007, 09:48 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Why is my 3rd x axis values only showing the bullets & not line?

Are there gaps in the data? If so, select the chart, go to Tools menu >
Options > Chart, and in the top section, choose the option to interpolate
over blank cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"marian" <marian@discussions.microsoft.com> wrote in message
news:A7E028A6-A946-42F7-8013-4B030BBAFA2A@microsoft.com...
>I have 3 values for my x axis. With each value I have chosen the line
>graph.
> My 3rd value only shows the bullets and not the line. I have tried
> changing
> the color but that doesn't work. My first 2 lines are correct. Can't
> find
> where I am doing something wrong



  Reply With Quote
Old 14-08-2007, 10:04 PM   #3
=?Utf-8?B?bWFyaWFu?=
Guest
 
Posts: n/a
Default Re: Why is my 3rd x axis values only showing the bullets & not lin

That did it!! Thank you very much!!

"Jon Peltier" wrote:

> Are there gaps in the data? If so, select the chart, go to Tools menu >
> Options > Chart, and in the top section, choose the option to interpolate
> over blank cells.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "marian" <marian@discussions.microsoft.com> wrote in message
> news:A7E028A6-A946-42F7-8013-4B030BBAFA2A@microsoft.com...
> >I have 3 values for my x axis. With each value I have chosen the line
> >graph.
> > My 3rd value only shows the bullets and not the line. I have tried
> > changing
> > the color but that doesn't work. My first 2 lines are correct. Can't
> > find
> > where I am doing something wrong

>
>
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off