I tried building a chart that displays 1 series in dollar sales and 1 series in unit sales. I tried putting one on a secondary axis, but it always overlaps the columns and changing the series overlap setting doesn't seem to have any effect? Does any one know what is going on and how I can separate columns on separate axis? Thanks, Jamie
You need to add a couple dummy series to help align the visible series: http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jamie" wrote in message news:C049CF24-A687-4166-A567-E3CF2EDCCB33@microsoft.com... >I tried building a chart that displays 1 series in dollar sales and 1 >series > in unit sales. I tried putting one on a secondary axis, but it always > overlaps the columns and changing the series overlap setting doesn't seem > to > have any effect? Does any one know what is going on and how I can separate > columns on separate axis? > > Thanks, > Jamie
