Could you add the line series as an XY Scatter series? use the same X
values as for the X Axis helper series.

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

hifert wrote:

hi,

i've read John Mansfield's solution at
http://www.excelforum.com//showthread.php?t=332217 but it's not quite
what i'm after since for the line i only have one data point per
cluster/month and not three as in his example...

ideally i would like to add a line series to Bernard Liengme’s
stacked-clustered chart example at
http://www.stfx.ca/people/bliengme/E...ps/Columns.htm as my charts
are based on it and i like his x-axis labelling format...

thanks in advance for any help,

anthony