Adding new series to chart with two series types

B

Bill

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
 
M

medicenpringles

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
sideways stacked bar charts with line series on the same axis 0
Chart series select. 3
Line chart with dotted lines rendered poorly in presentation mode 0
XL2007: stock chart- difficulty adding additional series 1
Excel 2007 Chart mouse hover sensitivity 0
Chart data scrunches to left when adding X axis date series 0
adding trendline to plots from multiple series 1

Top