Clustered column chart for year over year quarterly data, improper spacing(pivot table)

How can I group columns in Clustered column chart for year over year quarterly data(pivot table)? In the example, I wish to have 2016 and 2017 values for a particular month grouped together for proper comparison. (I manually changed the column colours for 2017, for the time being)pivot table and chart

Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like