Adding new series to chart with two series types

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

Guest

I have a chart with two column series and one line series. I want to add
several new column chart series but when I try the new series always seem to
be added as lines charts. I'm testing this manually but I'm intending to add
this to an exising macro so the new series are added programatically.

Is there a way to force the new charts to be a specific type, in this case,
column charts?

TIA
 
have you tried custom charting? when i did it, it made my third serie
a column, but when i created the chart, i right-clicked the series
clicked chart type, and changed it to Line chart. that should work
 
Back
Top