Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a line - bar graph bar first and line all others? | Charts and Charting in Excel | |||
Change line to bar in Line - Column graph | Charts and Charting in Excel | |||
How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
How do you drop the line in a line graph? | Charts and Charting in Excel |