I want to organize the charted results in decending order of longest bar to
shortest bar so a natural progression or trend can be seen easily. Help!!
I want to organize the charted results in decending order of longest bar to
shortest bar so a natural progression or trend can be seen easily. Help!!
kim -
Usually a chart depends on data in a worksheet.
So, sort the data.
- Mike
www.mikemiddleton.com
"kim" <[email protected]> wrote in message
news:[email protected]...
>I want to organize the charted results in decending order of longest bar to
> shortest bar so a natural progression or trend can be seen easily. Help!!
An alternative to Mike's suggestion is to do the sort through a named
formula. Create a named formula named DataRng (Insert | Name >
Define...) that refers to your data set. Then, add another named
formula (SortedData2 below).
DataRng =Sheet1!$D$5:$D$34
SortedData2 =LARGE(DataRng,ROW(DataRng)-ROW(INDEX(DataRng,1))+1)
Now, plot SortedData2. For more on named formulas and charts see they
Dynamic Charts page of my web site. [I'm on a plane and cannot provide
you the exact URL.]
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article <[email protected]>,
[email protected] says...
> I want to organize the charted results in decending order of longest bar to
> shortest bar so a natural progression or trend can be seen easily. Help!!
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks