I'm using Excel 2013.
In the attached graph, I would like to change the groups or pairs. Currently, 2014 is one group and 2015 another group. I would like to try it with four groups - ID, MH, SA, and NC. It would look the same, but ID 2014 and ID 2015 would be a pair with the same color. The next pair would be MH 2014 and MH 2015. Then the same with the next two. Each pair would have a different color. I know I'm missing something simple. Thanks for any assistance or helpful links.
You could use the Switch row/cols button give 1 variation where the ID columns are 1 colour and MH another, etc.
Or change the data layout so the columns are staggered. Then set the Overlap property to 100 and the reduce the Gap width,
Thank you, Andy. That is exactly what I need. I'll probably go with your second suggestion using the staggered column layout.
I'm also bookmarking your link. Those tips will be helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks