Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing unrelated values according to the X axis | Charts and Charting in Excel | |||
showing all values on the Y axis | Charts and Charting in Excel | |||
x axis not showing correct values | Charts and Charting in Excel | |||
Axis values showing incomplete | Charts and Charting in Excel | |||
How do I change x axis values in a line chart? | Charts and Charting in Excel |