Many, many, many Excel users post this problem in user forums. And this one always throws me for a loop and takes me time to solve it. So I thought I would send it out to all the Excel enthusiasts to see if you can fix this Excel Chart.
1) Copy this Data into an Excel Worksheet
However, my data series are not of the same scale, so, I decide to create 2 vertical axis’ so that the scales are distinct for the two data series. So then I go to the next step.
OOPS! This is not the chart I wanted . Why is my Excel charts now an Excel Stacked Colum Chart? I just want the two columns in my chart to be separated on 2 different vertical axis. How can I fix it?
How would you make this 2-D Clustered Column Chart with two vertical axis scales?
Copy the data from above and give it a try. Let me know how you would create this chart in the comments below. Regardless, comeback tomorrow and see how we can handle this using Excel Charts.