LinkBack URL
About LinkBacks
Hi I'd like to separate 1 column and combine 2 others.
For example in this file I'd like the blue column to be alone and the to others merged
https://docs.google.com/file/d/0B1XY...it?usp=sharing
Can somebody help?
Regards,
Bryan
Hi I'd like to separate 1 column and combine 2 others.
For example in this file I'd like the blue column to be alone and the to others merged
https://docs.google.com/file/d/0B1XY...it?usp=sharing
Can somebody help?
Regards,
Bryan
you can use a dummy series, a secondary axis and adjust the gap width and overlap settings to get the appearance you want
Josie
if at first you don't succeed try doing it the way your wife told you to
Ohh thanks a lot!
How did you do that??
THanks again!!
I formatted the second two series to plot on the secondary axis, then changed their chart type to stacked column
I added a dummy blank series to the first axis for spacing
I adjusted the gap width of the series until they spaced properly
Then I adjusted the axis scales so they both matched each other and finally deleted the legend entry for the dummy series
as best I remember ;-)
Perfect thanks a lot!!
you're welcome :-)
please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks