PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Why is my 3rd x axis values only showing the bullets & not line?
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Why is my 3rd x axis values only showing the bullets & not line?
![]() |
Why is my 3rd x axis values only showing the bullets & not line? |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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 > > > |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

