Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
How do I display columns side-by-side in a two Y axis chart?
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
How do I display columns side-by-side in a two Y axis chart?
 |
How do I display columns side-by-side in a two Y axis chart? |
|
|
Thread Tools | Rate Thread |
05-04-2006, 07:29 AM
|
#1 |
|
Guest
Posts: n/a
|
How do I display columns side-by-side in a two Y axis chart?
Hi there all
I have a chart that has 2 Y axis. How can I move the columns to display side by side and not overlaping or one data set sitting in front of/behind the other? Help please this is driving me nuts. Many thanks |
|
|
05-04-2006, 11:30 AM
|
#2 |
|
Guest
Posts: n/a
|
Re: How do I display columns side-by-side in a two Y axis chart?
Hi,
You need to stagger your data to stop the 2 sets of columns overlapping each other. See here for information. http://peltiertech.com/Excel/Charts...usterStack.html Cheers Andy Kristin C wrote: > Hi there all > > I have a chart that has 2 Y axis. How can I move the columns to display > side by side and not overlaping or one data set sitting in front of/behind > the other? > > Help please this is driving me nuts. > > Many thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
|
|
05-04-2006, 12:20 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: How do I display columns side-by-side in a two Y axis chart?
Andy seems to have copied the wrong link. Try this:
http://peltiertech.com/Excel/Charts...sOnTwoAxes.html Andy Pope wrote: > Hi, > > You need to stagger your data to stop the 2 sets of columns overlapping > each other. > See here for information. > http://peltiertech.com/Excel/Charts...usterStack.html > > Cheers > Andy > > Kristin C wrote: > >> Hi there all >> >> I have a chart that has 2 Y axis. How can I move the columns to >> display side by side and not overlaping or one data set sitting in >> front of/behind the other? >> >> Help please this is driving me nuts. >> >> Many thanks > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
|
|
05-04-2006, 12:35 PM
|
#4 |
|
Guest
Posts: n/a
|
Re: How do I display columns side-by-side in a two Y axis chart?
This is probably a better link for that problem:
http://peltiertech.com/Excel/Charts...sOnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Andy Pope" <andy@andypope.info> wrote in message news:unq3CwJWGHA.840@TK2MSFTNGP04.phx.gbl... > Hi, > > You need to stagger your data to stop the 2 sets of columns overlapping > each other. > See here for information. > http://peltiertech.com/Excel/Charts...usterStack.html > > Cheers > Andy > > Kristin C wrote: >> Hi there all >> >> I have a chart that has 2 Y axis. How can I move the columns to display >> side by side and not overlaping or one data set sitting in front >> of/behind the other? >> >> Help please this is driving me nuts. >> >> Many thanks > > -- > > Andy Pope, Microsoft MVP - Excel > http://www.andypope.info |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
