Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How can I have a 2yaxis column chart, without columns overlapping

Everytime I try to have a 2 axis column chart the graph columns overlap.
With a single axis the columns are side by side (which i want but can't
achieve with 2 axis). Any ideas?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default How can I have a 2yaxis column chart, without columns overlapping

Hi,

The trick is in the layout of your data.
See here for details
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

Cheers
Andy
--

--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mazsheps" wrote in message
...
Everytime I try to have a 2 axis column chart the graph columns overlap.
With a single axis the columns are side by side (which i want but can't
achieve with 2 axis). Any ideas?


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
Overlapping Bars Chart & Two Y Axes: how? Jay Charts and Charting in Excel 1 September 11th 06 07:58 PM
text overlapping into the next columns Lemon Dainty Excel Discussion (Misc queries) 7 July 27th 06 01:37 PM
How to plot an overlapping Tubes chart? Overlapping Tubes Chart Charts and Charting in Excel 1 December 24th 05 11:40 AM
Can I keep the bubbles in my bubble chart from overlapping? B_Gr Charts and Charting in Excel 1 May 21st 05 05:56 PM
How do I stop axis titles from overlapping with negative chart da. KarenNeedsHelp Charts and Charting in Excel 2 May 15th 05 04:28 AM


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Excel"