Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 13
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 13
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a line - bar graph bar first and line all others? jk9533 Charts and Charting in Excel 0 April 6th 07 06:40 PM
Change line to bar in Line - Column graph Yonke Charts and Charting in Excel 4 January 16th 07 01:42 AM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 07:43 PM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM
How do you drop the line in a line graph? LisaM Charts and Charting in Excel 1 September 13th 06 08:56 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"