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.

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

"Ask MS" wrote in message
...
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.

Thank you, Bob, that is right!



"Bob Phillips" wrote:

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

"Ask MS" wrote in message
...
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.