[SOLVED] cluster & stacked & line in one chart

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 > Options > Chart tab, and choose Interpolate for Treat Blank Cells
As...

If the cells are formulas returning "", change "" 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 -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Scott" <[email protected]> wrote in message
news:[email protected]...
>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?

The cells are blank, but the interpolate option is grayed out and cannot be
selected.

"Jon Peltier" wrote:

> If the cells between the values for the line series are blank, go to Tools
> menu > Options > Chart tab, and choose Interpolate for Treat Blank Cells
> As...
>
> If the cells are formulas returning "", change "" 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 -
> http://PeltierTech.com/
> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
> http://peltiertech.com/Excel/ExcelUserConf06.html
> _______
>
> "Scott" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>

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
http://PeltierTech.com/
_______

"Scott" <[email protected]> wrote in message
news:[email protected]...
> The cells are blank, but the interpolate option is grayed out and cannot
> be
> selected.
>
> "Jon Peltier" wrote:
>
>> If the cells between the values for the line series are blank, go to
>> Tools
>> menu > Options > Chart tab, and choose Interpolate for Treat Blank Cells
>> As...
>>
>> If the cells are formulas returning "", change "" 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 -
>> http://PeltierTech.com/
>> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
>> http://peltiertech.com/Excel/ExcelUserConf06.html
>> _______
>>
>> "Scott" <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>>
>>
>>