Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
not able to link chart points from same series
I'm working on a chart that pull information from several pages.
Tha table is able to plot information correctly in the graph but I can't seem to link the dots on the chart with a line. Everytime I try a linear chart or a scatered chart with smoth lines, the lines start from the x axis and reach the dot rather than connecting dots from the same series. suggestions would be greatly appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
not able to link chart points from same series
If the points are not in the same series (i.e., the data source is from
different sheets, not a single summary sheet), you will never link them. If you have gaps, true actual blanks (not a formula hiding behind ""), you can do Tools menu Options Chart tab, and change treatment of blanks to Interpolate. If you have formulas returning "" for missing values, remember that "" is text, which Excel thinks has a value of 0. Change "" to NA(), and use conditional formatting to hide the #N/A error displayed in the cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ " wrote in message ... I'm working on a chart that pull information from several pages. Tha table is able to plot information correctly in the graph but I can't seem to link the dots on the chart with a line. Everytime I try a linear chart or a scatered chart with smoth lines, the lines start from the x axis and reach the dot rather than connecting dots from the same series. suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
excel chart maximum series should more than 255 series | Charts and Charting in Excel | |||
Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
Hiding a non-plotted chart series in legend | Excel Discussion (Misc queries) | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel |