software

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

Hi,

You need to stagger your data to stop the 2 sets of columns overlapping
each other.
See here for information.
peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Kristin C wrote:
gt; Hi there all
gt;
gt; I have a chart that has 2 Y axis. How can I move the columns to display
gt; side by side and not overlaping or one data set sitting in front of/behind
gt; the other?
gt;
gt; Help please this is driving me nuts.
gt;
gt; Many thanks

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Andy seems to have copied the wrong link. Try this:

peltiertech.com/Excel/Charts/...OnTwoAxes.html

Andy Pope wrote:
gt; Hi,
gt;
gt; You need to stagger your data to stop the 2 sets of columns overlapping
gt; each other.
gt; See here for information.
gt; peltiertech.com/Excel/ChartsH...sterStack.html
gt;
gt; Cheers
gt; Andy
gt;
gt; Kristin C wrote:
gt;
gt;gt; Hi there all
gt;gt;
gt;gt; I have a chart that has 2 Y axis. How can I move the columns to
gt;gt; display side by side and not overlaping or one data set sitting in
gt;gt; front of/behind the other?
gt;gt;
gt;gt; Help please this is driving me nuts.
gt;gt;
gt;gt; Many thanks
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

This is probably a better link for that problem:

peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; You need to stagger your data to stop the 2 sets of columns overlapping
gt; each other.
gt; See here for information.
gt; peltiertech.com/Excel/ChartsH...sterStack.html
gt;
gt; Cheers
gt; Andy
gt;
gt; Kristin C wrote:
gt;gt; Hi there all
gt;gt;
gt;gt; I have a chart that has 2 Y axis. How can I move the columns to display
gt;gt; side by side and not overlaping or one data set sitting in front
gt;gt; of/behind the other?
gt;gt;
gt;gt; Help please this is driving me nuts.
gt;gt;
gt;gt; Many thanks
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info