cluster & stacked & line in one chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
_______
 
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/
_______
 
Back
Top