View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ask MS[_2_] Ask MS[_2_] is offline
external usenet poster
 
Posts: 8
Default Custom type chart

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.