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" <(E-Mail Removed)> wrote in message
news:5D71D864-A2E4-45A5-9F8E-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:5D71D864-A2E4-45A5-9F8E-(E-Mail Removed)...
> > 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.
>
>
>