graph column line graph with two axes
in [Charts]
|
From: trichens on 26 Apr 2010 14:47 I need to make a graph with two axes, one series as a column and two different series as a line graph. When I add a new series, I can get one column and one line, but when I add the third series it turns the second series from a line to a column. How can I add two lines graphs and only one column.
From: Bernard Liengme on 26 Apr 2010 14:58 Make a column chart (not stacked) of the three series Right click one data series on the chart; use Chart Type and make it a Line type The other two should stay as Column charts. Now decide which are to use the primary and which the secondary axis best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "trichens" <trichens(a)discussions.microsoft.com> wrote in message news:33143BF6-112E-4D70-81F0-C3365CAE3254(a)microsoft.com... > I need to make a graph with two axes, one series as a column and two > different series as a line graph. When I add a new series, I can get one > column and one line, but when I add the third series it turns the second > series from a line to a column. How can I add two lines graphs and only > one > column.
|
Pages: 1 Prev: What is Excel EZAnalyze? Next: Creating separate graphs for columns of data |