Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kristin C
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
how to show date on the x axis of a line chart? Ginger Charts and Charting in Excel 4 May 1st 05 02:11 AM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 07:25 PM
Axis display as category doco Charts and Charting in Excel 4 December 12th 04 05:45 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"