Here's a VBA method.. this goes to the sheet module of course...
Regards,
Sam Mathai Chacko
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, ActiveSheet.Cells.Find("Top
Poster").Resize(11, 2)) Is Nothing Then
Application.EnableEvents = 0
Thanks Ashish , It does work well. However I used the rank function to sort
the data in different range.
Sam, All the solutions are most welcome.
I am looking at the solutions where we can sort chart without using the
additional range. Sometimes the complex sheets with large number of charts
dont
Ashish, nice improvisation.
Ayush, has that solution from solved your question? or are you looking for
any other solution
Sam
On Sat, Sep 17, 2011 at 5:47 PM, ashish koul wrote:
> check the attachement
>
>
> On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain wrote:
>
>> Dear group,
>>
>> Recently in
check the attachement
On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain wrote:
> Dear group,
>
> Recently in one of the project, I encountered an issue where we need to
> sort the 2-D Bar chart from high to low without sorting the data table
> The data table could not be sorted because it is linked wi
Dear group,
Recently in one of the project, I encountered an issue where we need to sort
the 2-D Bar chart from high to low without sorting the data table
The data table could not be sorted because it is linked with some dynamic
formulas.
Enclosed is the sample data and chart for you, where I jum
