Hi,
I thought this would be easy or at least possible to figure out but i'm struggling.How can I split the data to show them as two bar charts side by side? I can add the secondary axis but the plotted data overlaps each other.
Example attached.
Thanks,
Snook
Last edited by The_Snook; 02-27-2013 at 12:48 PM.
Hi The Snook
I would recommend adding adding a few rows in your data.
Then after you move one series to the 2nd axis, increase the gap of that series to about 250%
Double Axis Bar Chart Query.xlsx
Let me know if this helps
Steve=True
Cheers Steve=True
It sort of works but not quite what i'm after. Why are the bars different widths and why do they overlap to varying degrees?
You need 2 series to hold the position of right and left columns in the cluster.
Move both the Left Pad and data to the secondary axis and then there is no need to adjust overlap.
Thanks, that's exactly what i'm after!
What's the best way to remove/hide the PadRight and PadLeft from the legend?
select each individually legend entry and delete
Simples!
Cheers Andy!
Thanks Andy,
I was so close
Steve=True
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks