Custom type chart

[Ask MS]

How can I make a chart with two series of Columns and one serie of line? For
example, I need to, in the same chart, show Product A's and B's net sales
from several months by two series of columns, and then show the percentage of
A to B (A/B) by a line.

 

[Bob Phillips]

Create a chart with all of the data series in a clustered column chart.

Then select the data series for the one you want as a line, right-click, and
select chart type and change that one to a line.

 

[Ask MS]

Thank you, Bob, that is right!

Create a chart with all of the data series in a clustered column chart.

Then select the data series for the one you want as a line, right-click, and
select chart type and change that one to a line.

--
__________________________________
HTH

Bob