How do I set up a line - bar graph bar first and line all others?
 

I trying to use the line - bar graph so that the current year is a bar and
all other data sets are line, but the default for this chart type groups have
of them as bars and half as charts. How do I get around this?

How do I set up a line - bar graph bar first and line all others?
 

jk9533 wrote on Fri, 6 Apr 2007 10:42:02 -0700:

j I trying to use the line - bar graph so that the current
j year is a bar and all other data sets are line, but the
j default for this chart type groups have of them as bars and
j half as charts. How do I get around this?

I think I succeeded in doing it but I am prepared to be
corrected. Draw all the series as lines and change the chart
type of the one you want to bar.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

How do I set up a line - bar graph bar first and line all othe
 

Worked thanks

"James Silverton" wrote:

jk9533 wrote on Fri, 6 Apr 2007 10:42:02 -0700:

j I trying to use the line - bar graph so that the current
j year is a bar and all other data sets are line, but the
j default for this chart type groups have of them as bars and
j half as charts. How do I get around this?

I think I succeeded in doing it but I am prepared to be
corrected. Draw all the series as lines and change the chart
type of the one you want to bar.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

How do I set up a line - bar graph bar first and line all othe
 

Actually I wanna draw Co-graph ie x-x1-y graph. how do I do with 2007

"James Silverton" wrote:

jk9533 wrote on Fri, 6 Apr 2007 10:42:02 -0700:

j I trying to use the line - bar graph so that the current
j year is a bar and all other data sets are line, but the
j default for this chart type groups have of them as bars and
j half as charts. How do I get around this?

I think I succeeded in doing it but I am prepared to be
corrected. Draw all the series as lines and change the chart
type of the one you want to bar.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

How do I set up a line - bar graph bar first and line all othe
 

You mean you want two series, one using X vs Y, the other using X1 vs Y?
Create the chart using X vas Y, then copy the X1-Y data, select the chart,
and use Paste Special to add the data as a new series. Format each series
separately, and if necessary display the X1-Y series on the secondary axis
if X and X1 use incompatible axis scales. Sometimes when you move a series
to the secondary axis, Excel adds a secondary Y axis (which you can remove)
but not a primary X axis. You can add this using the controls on the Chart
Tools contextual tabs.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Deepak P" <Deepak wrote in message
...
Actually I wanna draw Co-graph ie x-x1-y graph. how do I do with 2007

"James Silverton" wrote:

jk9533 wrote on Fri, 6 Apr 2007 10:42:02 -0700:

j I trying to use the line - bar graph so that the current
j year is a bar and all other data sets are line, but the
j default for this chart type groups have of them as bars and
j half as charts. How do I get around this?

I think I succeeded in doing it but I am prepared to be
corrected. Draw all the series as lines and change the chart
type of the one you want to bar.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not