+ Reply to Thread
Results 1 to 4 of 4

How do I display columns side-by-side in a two Y axis chart?

  1. #1
    Kristin C
    Guest

    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

  2. #2
    Andy Pope
    Guest

    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/ChartsH...sterStack.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

  3. #3
    Andy Pope
    Guest

    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/...OnTwoAxes.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/ChartsH...sterStack.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

  4. #4
    Jon Peltier
    Guest

    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/...OnTwoAxes.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/ChartsH...sterStack.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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1