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 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.
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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks