Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot see graph lines on the chart
I've created a chart with 3 data series. I chose "lines with markers" as the
format. For each series, the data markers appear correctly, but there are no graph lines joining them up. I've checked out "Format data series" .... Pattern tab .... and can see the lines in the sample, but they just don't appear on the chart. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot see graph lines on the chart
Hi,
Are the values of the series within the range of the axes scale? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Guy" wrote in message ... I've created a chart with 3 data series. I chose "lines with markers" as the format. For each series, the data markers appear correctly, but there are no graph lines joining them up. I've checked out "Format data series" .... Pattern tab .... and can see the lines in the sample, but they just don't appear on the chart. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot see graph lines on the chart
Andy - yes.
"Andy Pope" wrote: Hi, Are the values of the series within the range of the axes scale? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Guy" wrote in message ... I've created a chart with 3 data series. I chose "lines with markers" as the format. For each series, the data markers appear correctly, but there are no graph lines joining them up. I've checked out "Format data series" .... Pattern tab .... and can see the lines in the sample, but they just don't appear on the chart. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot see graph lines on the chart
If you want to email the offending file direct to me I will take a look.
Cheers Andy Guy wrote: Andy - yes. "Andy Pope" wrote: Hi, Are the values of the series within the range of the axes scale? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Guy" wrote in message ... I've created a chart with 3 data series. I chose "lines with markers" as the format. For each series, the data markers appear correctly, but there are no graph lines joining them up. I've checked out "Format data series" .... Pattern tab .... and can see the lines in the sample, but they just don't appear on the chart. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot see graph lines on the chart
Select the chart and use the menu, Tools Options Chart. Check the
interpolate option in order to get the lines plotted. You have points for the category axis but not corresponding y value. The current setting for empty cells is not to plot, which is why the points are there for data with no line joining the points. With the interpolate option a line will be plotted between points. Cheers Andy Guy wrote: Andy - yes. "Andy Pope" wrote: Hi, Are the values of the series within the range of the axes scale? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Guy" wrote in message ... I've created a chart with 3 data series. I chose "lines with markers" as the format. For each series, the data markers appear correctly, but there are no graph lines joining them up. I've checked out "Format data series" .... Pattern tab .... and can see the lines in the sample, but they just don't appear on the chart. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel | |||
How do i get lines on a line graph? | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
smooth graph lines | Excel Discussion (Misc queries) | |||
graph with one column and two lines | Excel Discussion (Misc queries) |