ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I have a 2yaxis column chart, without columns overlapping (https://www.excelbanter.com/charts-charting-excel/136498-how-can-i-have-2yaxis-column-chart-without-columns-overlapping.html)

mazsheps

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?

Andy Pope

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?




All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com