software

I have a chart that has one clustered column and two stacked columns. Looks
great. I tried to format another set of data to be a line with markers. All
I see is the markers, no line. Any ideas if this is possible?

If the cells between the values for the line series are blank, go to Tools
menu gt; Options gt; Chart tab, and choose Interpolate for Treat Blank Cells
As...

If the cells are formulas returning quot;quot;, change quot;quot; to NA(). This puts an ugly
#N/A error in the sheet, but the chart automatically interpolates across
these errors without showing them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Scottquot; gt; wrote in message
...
gt;I have a chart that has one clustered column and two stacked columns.
gt;Looks
gt; great. I tried to format another set of data to be a line with markers.
gt; All
gt; I see is the markers, no line. Any ideas if this is possible?
The cells are blank, but the interpolate option is grayed out and cannot be
selected.

quot;Jon Peltierquot; wrote:

gt; If the cells between the values for the line series are blank, go to Tools
gt; menu gt; Options gt; Chart tab, and choose Interpolate for Treat Blank Cells
gt; As...
gt;
gt; If the cells are formulas returning quot;quot;, change quot;quot; to NA(). This puts an ugly
gt; #N/A error in the sheet, but the chart automatically interpolates across
gt; these errors without showing them.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Scottquot; gt; wrote in message
gt; ...
gt; gt;I have a chart that has one clustered column and two stacked columns.
gt; gt;Looks
gt; gt; great. I tried to format another set of data to be a line with markers.
gt; gt; All
gt; gt; I see is the markers, no line. Any ideas if this is possible?
gt;
gt;
gt;

Oh yeah, Interpolate is meaningless for a column chart. You have to make the
chart a line chart, select the Interpolate option, then change the relevant
series back to column type.

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

quot;Scottquot; gt; wrote in message
...
gt; The cells are blank, but the interpolate option is grayed out and cannot
gt; be
gt; selected.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; If the cells between the values for the line series are blank, go to
gt;gt; Tools
gt;gt; menu gt; Options gt; Chart tab, and choose Interpolate for Treat Blank Cells
gt;gt; As...
gt;gt;
gt;gt; If the cells are formulas returning quot;quot;, change quot;quot; to NA(). This puts an
gt;gt; ugly
gt;gt; #N/A error in the sheet, but the chart automatically interpolates across
gt;gt; these errors without showing them.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;Scottquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a chart that has one clustered column and two stacked columns.
gt;gt; gt;Looks
gt;gt; gt; great. I tried to format another set of data to be a line with
gt;gt; gt; markers.
gt;gt; gt; All
gt;gt; gt; I see is the markers, no line. Any ideas if this is possible?
gt;gt;
gt;gt;
gt;gt;