Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an excel sheet with 6 separate ranked charts on it. I am able
to sort 5 of these charts in descending order. Excel will not allow me to sort the 6th chart in the same way. I keep getting a "This operation requires the merged cells to be equally sized" message. Yes, it is the only chart with merged cells on the whole sheet. I did this because I wanted larger cells in this chart than in the charts sharing the same rows to its right. Any suggestions on how to fix this? Here is a photo link of the chart, to give you an idea of what I'm trying to do. The problem is with the "League Leaderboard" chart on the left. http://www.flickr.com/photo_zoom.gne...5235424&size=o Thanks B |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Almost forgot to mention that the cells I am trying to sort are all
the same size. Hence my confusion. On Mar 9, 1:36 pm, "orpheusgrey" wrote: I have an excel sheet with 6 separate ranked charts on it. I am able to sort 5 of these charts in descending order. Excel will not allow me to sort the 6th chart in the same way. I keep getting a "This operation requires the merged cells to be equally sized" message. Yes, it is the only chart with merged cells on the whole sheet. I did this because I wanted larger cells in this chart than in the charts sharing the same rows to its right. Any suggestions on how to fix this? Here is a photo link of the chart, to give you an idea of what I'm trying to do. The problem is with the "League Leaderboard" chart on the left. http://www.flickr.com/photo_zoom.gne...5235424&size=o Thanks B |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
See one response at your other thread.
orpheusgrey wrote: Almost forgot to mention that the cells I am trying to sort are all the same size. Hence my confusion. On Mar 9, 1:36 pm, "orpheusgrey" wrote: I have an excel sheet with 6 separate ranked charts on it. I am able to sort 5 of these charts in descending order. Excel will not allow me to sort the 6th chart in the same way. I keep getting a "This operation requires the merged cells to be equally sized" message. Yes, it is the only chart with merged cells on the whole sheet. I did this because I wanted larger cells in this chart than in the charts sharing the same rows to its right. Any suggestions on how to fix this? Here is a photo link of the chart, to give you an idea of what I'm trying to do. The problem is with the "League Leaderboard" chart on the left. http://www.flickr.com/photo_zoom.gne...5235424&size=o Thanks B -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with sorting and Worksheet protect | Excel Discussion (Misc queries) | |||
Trouble sorting first by a dates field and then by a text field. | Excel Discussion (Misc queries) | |||
Trouble with Sorting Hyperlinks | Excel Discussion (Misc queries) | |||
Trouble sorting linked worksheet - need help | Excel Discussion (Misc queries) | |||
Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) |