Visit the Blog site for other information about this post at: http://www.exceldashboardtemplates.co...
It may seem like Excel is changing your Clustered Column Chart to a Stacked Column Chart or your Bar Chart to a Stacked Bar chart when you move a series to the Secondary Axis, but don't worry, it isn't. Learn how to separate your columns or bars in your Excel Chart when you move a series to the secondary axis.
If you want to know how to do this with a chart from a pivot table, check out this post:
http://www.exceldashboardtemplates.co...