ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I offset TWO columns behind another TWO columns? (https://www.excelbanter.com/charts-charting-excel/52187-how-do-i-offset-two-columns-behind-another-two-columns.html)

Moxy1980

How do I offset TWO columns behind another TWO columns?
 

I have created a bar chart with 4 colums of information. I would like
two of the columns to be behind the other two colums. Can anyone help
me with how to do this.

I have tried creating the chart then offsetting but obviously all the
coumns offset behind each other.

Thanks in anticipation!


--
Moxy1980
------------------------------------------------------------------------
Moxy1980's Profile: http://www.excelforum.com/member.php...o&userid=28075
View this thread: http://www.excelforum.com/showthread...hreadid=479084


Andy Pope

How do I offset TWO columns behind another TWO columns?
 
Hi,

Set the two columns you want in front to be on the secondary y axis.

Cheers
Andy

Moxy1980 wrote:
I have created a bar chart with 4 colums of information. I would like
two of the columns to be behind the other two colums. Can anyone help
me with how to do this.

I have tried creating the chart then offsetting but obviously all the
coumns offset behind each other.

Thanks in anticipation!



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 12:10 AM.

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